0 ASM Views

 

• V$ASM_DISK
• V$ASM_DISKGROUP
• V$ASM_FILE
• V$ASM_CLIENT
• V$ASM_DISK_IOSTAT
• V$ASM_ATTRIBUTE
• V$ASM_TEMPLATE
• V$ASM_ALIAS
• V$ASM_OPERATION

 

 

V$ASM_DISK

 

SELECT

  group_number,label,name,path,mount_status,header_status, OS_MB

FROM

  v$asm_disk;

 

V$ASM_DISKGROUP

 

SELECT

  group_number,

  name,

  allocation_unit_size,

  state,

  total_MB,

  free_MB,

  compatibility

FROM

  v$asm_diskgroup

 

V$ASM_FILE

List files store in the ASM disk groups.

 

SELECT

  group_number,

  file_number,

  type,

  bytes

FROM

  v$asm_file;

 

 

V$ASM_CLIENT

List all the instance who connect to the ASM instance.

 

select * FROM V$ASM_CLIENT;

V$ASM_DISK_IOSTAT

 

 SELECT

  INSTNAME,

  DBNAME,

  GROUP_NUMBER,

  FAILGROUP,

  READS,

  WRITES

FROM

  V$ASM_DISK_IOSTAT;

 

V$ASM_ATTRIBUTE

 

SELECT

G.NAME AS DISKGROUP,

A.NAME AS NAME,

A.VALUE AS VALUE,

A.READ_ONLY

FROM

 V$ASM_ATTRIBUTE A, V$ASM_DISKGROUP G

WHERE

G.GROUP_NUMBER = A.GROUP_NUMBER;

 

V$ASM_TEMPLATE

 

select * from  V$ASM_TEMPLATE

 

V$ASM_ALIAS

select NAME,GROUP_NUMBER,ALIAS_DIRECTORY from V$ASM_ALIAS

V$ASM_OPERATION

Shoe the active operation in the ASM instance.