|
|
| |
 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Dynamic Performance Views on ASM
v$asm_disk - has information about
all disks in an ASM instance
which are independent or part of disk groups. In a database
instance, it has one row for every mounted disk.
|
Column |
Description |
|
GROUP_NUMBER |
Cluster-wide number for the disk
group containing the disk (foreign key to
v$asm_diskgroup) |
|
DISK_NUMBER |
Disk number within its disk group |
|
COMPOUND_INDEX |
32-bit number with disk group
number and disk number |
|
INCARNATION |
Incarnation number for the disk |
|
MOUNT_STATUS |
Per-instance status of the disk
relative to group mounts -OPENED, CLOSED, MISSING,CACHED |
|
HEADER_STATUS |
Status of the disk per instance
-MEMBER, FORMER, CANDIDATE, UNKNOWN, INCOMPATIBLE,
PROVISIONED,CONFLICT |
|
MODE_STATUS |
Global status about kinds of I/O
requests allowed to the disk - ONLINE, OFFLINE, UNKNOWN |
|
STATE |
Global state of the disk with
respect to its disk group -NORMAL, HUNG, ADDING,
DROPPING, FORCING, DROPPED, UNKNOWN |
|
REDUNDANCY |
External redundancy of the disk -
MIRROR, PARITY, UNPROT, UNKNOWN |
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
|
|
