V$ASM_CLIENT

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_CLIENT identifies databases using disk groups managed by the Oracle ASM instance. In a database instance, V$ASM_CLIENT displays information about the Oracle ASM instance if the database has any open Oracle ASM files.

Column Datatype Description

GROUP_NUMBER

NUMBER

Number of the disk group being used by the client database instance (foreign key to the V$ASM_DISKGROUP view). When a client is connected to an Oracle ASM instance, but is not currently using any disk groups, V$ASM_CLIENT.GROUP_NUMBER contains 0.

INSTANCE_NAME

VARCHAR2(64)

Identifier for the database instance client

DB_NAME

VARCHAR2(8)

Unique database name of the database client instance

CLUSTER_NAME

VARCHAR2(31)

Name of the cluster

STATUS

VARCHAR2(12)

Status of the client connection:

  • CONNECTED - Database instance client has an active connection to the Oracle ASM instance

  • DISCONNECTED - Database instance client normally ended its connection to the Oracle ASM instance

  • BROKEN - Connection with the database instance client terminated abnormally

SOFTWARE_VERSION

VARCHAR2(60)

Software version number of the database or Oracle ASM instance for the selected disk group connection

COMPATIBLE_VERSION

VARCHAR2(60)

Compatibility setting of the database or Oracle ASM instance for the selected disk group connection

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 additional information about using views to display Oracle ASM information