Sunday, January 6, 2013

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;

image

 

V$ASM_DISKGROUP

 

SELECT
  group_number,
  name,
  allocation_unit_size,
  state,
  total_MB,
  free_MB,
  compatibility
FROM
  v$asm_diskgroup

image

 

V$ASM_FILE

List files store in the ASM disk groups.

 

SELECT
  group_number,
  file_number,
  type,
  bytes
FROM
  v$asm_file;

image

 

 

V$ASM_CLIENT

List all the instance who connect to the ASM instance.

 

select * FROM V$ASM_CLIENT;

image

V$ASM_DISK_IOSTAT

 

 SELECT
  INSTNAME,
  DBNAME,
  GROUP_NUMBER,
  FAILGROUP,
  READS,
  WRITES
FROM
  V$ASM_DISK_IOSTAT;

image

 

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;

image

 

V$ASM_TEMPLATE

 

select * from  V$ASM_TEMPLATE

image

 

V$ASM_ALIAS

select NAME,GROUP_NUMBER,ALIAS_DIRECTORY from V$ASM_ALIAS

image

V$ASM_OPERATION

Shoe the active operation in the ASM instance.

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates