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

本站中文解释

_INFO

V$ASM_ACFSTAG_INFO视图用于检索从ASM实例向内部外显元数据服务发送的ACFS标记容器的状态,以及检索每个ASM集群中ACFS标记容器的连接状态。该视图提供有关ACFS标记容器的信息,该标记容器记录了ASM实例服务的数据库实例相关信息,例如数据库状态、一致性和磁盘组。

使用该视图的方法:

1、首先,运行SQL语句检索V$ASM_ACFSTAG_INFO视图中的信息,例如:SELECT * FROM v$asm_acfstag_info;

2、查询表格中的结果,获取有关ASM实例和ACFS标记容器的状态、连接状态等信息;

3、根据获取的信息,进行后续排查和应用操作,以解决相关问题。

官方英文解释

V$ASM_ACFSTAG displays every file or directory that has a tag and its tag name for every mounted Oracle ACFS.

Column Datatype Description

TAG_NAME

VARCHAR2(32)

Tag name on file or directory

FS_NAME

VARCHAR2(1024)

File system mount point

PATH_NAME

VARCHAR2(4096)

Complete file path name

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

For this view, the value is always 0.

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_ACFSTAG 官方解释,作用,如何使用详细说明