Home > Workload Solutions > Oracle > White Papers > Oracle ASM on ScaleIO Best Practices > CLIENTS.SQL
Table 16 includes compatibility information for the clients.sql script.
Table 16. Script details—clients.sql
Type of information |
Details |
Name |
clients.sql |
Compatibility |
10g, 11g, 12c |
Purpose |
Shows clients connected to the ASM instance. |
Sample output:
DB_NAME INSTANCE DISKGROUP_NAME STATUS SOFTWARE_VERSION COMPATIBLE_VERSION
------- -------- --------------- ------------ -------------------- ---------------
+ASM +ASM1 CRS CONNECTED 11.2.0.1.0 11.2.0.1.0
+ASM +ASM1 DATA CONNECTED 11.2.0.1.0 11.2.0.1.0
PHLORA PHLORA1 DATA CONNECTED 11.2.0.1.0 11.2.0.0.0
PHLORA PHLORA1 FRA CONNECTED 11.2.0.1.0 11.2.0.0.0
PHLORA PHLORA1 REDO CONNECTED 11.2.0.1.0 11.2.0.0.0
Table 17 contains the key to the output.
Table 17. Key to clients.sql columns
Column |
Meaning |
DB_NAME |
Database name of client |
INSTANCE |
Instance name of client |
DISKGROUP_NAME |
Diskgroup name |
STATUS |
Status of the client |
SOFTWARE_VERSION |
Version of the client |
COMPATIBLE_VERSION |
Version of the API |
Script text:
set linesize 132
set pagesize 999
col instance for a8
col software_version for a20
col compatible_version for a20
col diskgroup_name for a15
select
vac.db_name,
vac.instance_name "INSTANCE",
vad.name "DISKGROUP_NAME",
vac.status,
vac.software_version,
vac.compatible_version
from
v$asm_client vac,
v$asm_diskgroup vad
where 1=1
and vac.group_number = vad.group_number
order by 1,2,3