- 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.
0 comments:
Post a Comment