Oracle教程

Oracle 视图 V$ASM_ACFSAUTORESIZE 官方解释，作用，如何使用详细说明

本站中文解释

_SUMM

Oracle视图V$ASM_ACFSAUTORESIZE_SUMM可以查询ASM实例中ACFS文件系统发生自动调整大小的情况，及其它信息，比如ACFS文件系统名、发生自动调整前的大小、发生自动调整后的大小和发生的时间等。

使用方法： 在SQL *Plus 中输入语句：

SELECT * FROM V$ASM_ACFSAUTORESIZE_SUMM;

即可查询ASM实例中ACFS文件系统发生自动调整大小的情况。

官方英文解释

V$ASM_ACFSAUTORESIZE displays the auto-resize settings for each mounted Oracle ACFS file system.

Column Datatype Description

FS_NAME

VARCHAR2(1024)

Full path name of the Oracle ACFS file system mount point

RESIZE_INCREMENT

NUMBER

Auto-resize increment (in megabytes)

RESIZE_MAXIMUM

NUMBER

Auto-resize maximum (in megabytes)

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

See Also:

  • Oracle Automatic Storage
    Management Administrator’s Guide     for more information about Oracle Advanced Cluster File System (Oracle ACFS)

  • Oracle Automatic Storage
    Management Administrator’s Guide     for additional information about using views to display Oracle Advanced Cluster File System (Oracle ACFS) and Oracle ASM Dynamic Volume Manager (Oracle ADVM) information

Note:

To display information about Oracle ACFS file systems or volumes that are located on nodes in an Oracle Flex ASM configuration, you must connect to the Oracle ASM proxy instance instead of the local Oracle ASM instance. For information about Oracle Flex ASM, refer to Oracle Automatic Storage
Management Administrator’s Guide.


数据运维技术 » Oracle 视图 V$ASM_ACFSAUTORESIZE 官方解释，作用，如何使用详细说明
分享到：

相关推荐