ASM磁盤組資訊檢視常用指令

1.1           擷取磁盤組管理資訊

1.1.1        檢視磁盤路徑

SQL> selectname, path, group_number from v$asm_disk_stat ；

1.1.2        檢視磁盤組資訊

SQL> selectstate,name,type,total_mb, free_mb from v$asm_diskgroup_stat ;

磁盤組狀态為Mounted說明磁盤組狀态正常;

磁盤組的total_mb,free_mb為非0說明可以讀取磁盤資訊,擷取磁盤大小。

1.1.3        檢視磁盤組操作

select * fromv$asm_operation

OPERA STATPOWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES

----- -------------- ---------- ---------- ---------- ---------- -----------

1 REBAL WAIT11 0 0 0 0 0

1 DSCV WAIT 110 0 0 0 0

(timepasses…………..)

----------------- ---- ---------- ---------- ---------- ---------- ----------

1 REBAL REAP11 2 25 219 485 0

1.1.4        檢視磁盤組屬性

查詢V$ASM_ATTRIBUTE視圖檢視磁盤組屬性

SQL> SELECT dg.name AS diskgroup,SUBSTR(a.name,1,18) AS name,

SUBSTR(a.value,1,24) AS value, read_only FROM V$ASM_DISKGROUP_STAT dg,

V$ASM_ATTRIBUTE a WHERE dg.name = 'DATA'

AND dg.group_number = a.group_number;

1.1.5        檢視磁盤組相容屬性

SQL> SELECT name,COMPATIBILITY,DATABASE_COMPATIBILITY FROM V$ASM_DISKGROUP_STAT;

1.1.6        檢視磁盤狀态

SQL> SELECT SUBSTR(d.name,1,16) AS asmdisk,d.mount_status,HEADER_STATUS, d.state,

dg.name AS diskgroup FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_DISK_STAT d

WHERE dg.group_number = d.group_number;

1.1.7        檢視磁盤用戶端資訊

SQL> SELECT dg.name AS diskgroup,SUBSTR(c.instance_name,1,12) AS instance,

SUBSTR(c.db_name,1,12) AS dbname,SUBSTR(c.SOFTWARE_VERSION,1,12) AS software,

SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible

FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_CLIENT c

WHERE dg.group_number = c.group_number;

1.1.8        檢視磁盤通路控制使用者資訊

SQL> SELECT dg.name AS diskgroup, u.group_number,u.user_number, u.os_id, u.os_name

FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_USER u

WHERE dg.group_number = u.group_number AND dg.name ='DATA';

1.1.9        檢視磁盤通路控制組資訊

SQL> SELECT dg.name AS diskgroup, ug.group_number,ug.owner_number, u.os_name,

ug.usergroup_number, ug.name FROM V$ASM_DISKGROUP_STAT dg, V$ASM_USER u, V$ASM_USERGROUP ug

WHERE dg.group_number = ug.group_number AND dg.name ='DATA'

AND ug.owner_number = u.user_number;

1.1.10   檢視智能資料分布資訊

SQL> SELECT dg.name AS diskgroup, f.file_number, f.primary_region,f.mirror_region, f.hot_reads,f.hot_writes, f.cold_reads, f.cold_writes

FROM V$ASM_DISKGROUP_STAT  dg, V$ASM_FILE f

WHERE dg.group_number = f.group_number and dg.name ='DATA';

本文轉自xiaocao1314051CTO部落格，原文連結： http://blog.51cto.com/xiaocao13140/1932958，如需轉載請自行聯系原作者