Home > Workload Solutions > Oracle > White Papers > Oracle ASM on ScaleIO Best Practices > ATTRIBUTE.SQL
Table 14 includes compatibility information for the attribute.sql script.
Table 14. Script details—attribute.sql
Type of information |
Details |
Name |
attribute.sql |
Compatibility |
11g, 12c |
Purpose |
Shows attributes of the ASM instance. |
Sample output:
NAME VALUE GN ATINC RONLY SYS
--------------------------------------------- ---------- --- ------ ----- ----
access_control.enabled FALSE 1 1 N Y
access_control.umask 066 1 1 N Y
au_size 1048576 1 1 Y Y
cell.smart_scan_capable FALSE 1 1 N N
compatible.asm 11.2.0.0.0 1 1 N Y
compatible.rdbms 10.1.0.0.0 1 1 N Y
disk_repair_time 3.6h 1 1 N Y
sector_size 512 1 1 Y Y
template.ARCHIVELOG.mirror_region 0 1 1 N Y
<output removed to aid clarity>
template.XTRANSPORT.primary_region 0 1 1 N Y
template.XTRANSPORT.redundancy 17 1 1 N Y
template.XTRANSPORT.stripe 0 1 1 N Y
template_version 186646528 1 1 N Y
Table 15 contains the key to the output.
Table 15. Key to ATTRIBUTE.SCRIPT columns
Column |
Meaning |
NAME |
Attribute name |
VALUE |
Attribute value |
GN |
Group Number |
ATINC |
Attribute Incarnation |
RONLY |
Read Only |
SYS |
System Created |
Script text:
set linesize 132
set pagesize 999
col diskgroup_name a15
col name for a45
col value for a10
col atidx for 99999
col atinc for 99999
col gn for 99
col ronly for a5
col sys for a4
select
vad.name "DISKGROUP_NAME",
vaa.name,
vaa.value,
-- vaa.group_number "GN",
-- vaa.attribute_index "ATIDX",
-- vaa.attribute_incarnation "ATINC",
vaa.read_only "RONLY",
vaa.system_created "SYS"
from
v$asm_attribute vaa,
v$asm_diskgroup vad
where 1=1
and vaa.group_number = vad.group_number
order by vaa.name
/