ASM diskgroup information view common commands

1.1 get disk group management information

1.1.1 View disk path

SQL > selectname, path, group_number from v$asm_disk_stat

1.1.2 View disk group information

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

The disk group status is Mounted, which means the disk group status is normal.

The total_mb,free_mb of the disk group is non-0, which means you can read the disk information and obtain the disk size.

1.1.3 View disk group operation

Select * fromv$asm_operation

OPERA STATPOWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES

1 REBAL WAIT11 0 0 0

1 DSCV WAIT 110 0 0 0

(timepasses). .)

OPERA STATPOWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES

-

1 REBAL REAP11 2 25 219 485 0

1.1.4 View disk group properties

Query the V$ASM_ATTRIBUTE view to view disk group properties

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

SUBSTR (a. Valuememe1 and 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 View disk group compatibility properties

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

1.1.6 View disk status

SQL > SELECT SUBSTR (d. Name not 1 pr. 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 View disk client information

SQL > SELECT dg.name AS diskgroup,SUBSTR (c. Instanceyogname1 pr. 12) AS instance

SUBSTR (c. DbsancnameMagol 1pr 12) AS dbname,SUBSTR (c. SOFTWAREREVERSION Magazine 1mr12) AS software

SUBSTR (c.COMPATIBLER versionVERSION journal 1 and 12) AS compatible

FROM V$ASM_DISKGROUP_STAT dg, V$ASM_CLIENT c

WHERE dg.group_number = c.group_number

1.1.8 View disk access control user information

SQL > SELECT dg.name AS diskgroup, u.grouproomnumber.u.username numbering, 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 View disk access control group information

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 View smart data distribution information

SQL > SELECT dg.name AS diskgroup, f.file_number, f. Mirrorial region, f. Hotspot 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'