V$ASM_CLIENT

V$ASM_CLIENT displays 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:
  • CONNECTED - Database instance client has an active connection to the Automatic Storage Management instance

  • DISCONNECTED - Database instance client normally ended its connection to the Automatic Storage Management instance

  • BROKEN - Connection with the database instance client terminated abnormally

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