Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$ASM_CLIENT

In an Automatic Storage Management instance, V$ASM_CLIENT identifies databases using disk groups managed by the ASM instance. In a database instance, V$ASM_CLIENT displays information about the ASM instance if the database has any open 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)
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