V$ASM_CLIENT
returns one row for each open ASM disk group.
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) |
INSTANCE_NAME |
VARCHAR2(64) |
Identifier for the database instance client |
DB_NAME |
VARCHAR2(8) |
Unique database name of the database client instance |
STATUS |
VARCHAR2(12) |
Status of the client connection:
|
SOFTWARE_VERSION |
VARCHAR2(60) |
Software version number of the database or Automatic Storage Management instance for the selected disk group connection |
COMPATIBLE_VERSION |
VARCHAR2(60) |
Compatibility setting of the database or Automatic Storage Management instance for the selected disk group connection |