V$ASM_CLIENT

In an Automatic Storage Management instance, V$ASM_CLIENT displays one row for every database instance using a disk group managed by the Automatic Storage Management instance. In a database instance, V$ASM_CLIENT displays one row for the Automatic Storage Management instance if the database has open Automatic Storage Management 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