Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$ASM_CLIENT

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:
  • 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