ASM Disk (PD_PDDK)
- Organization of this page
Function
The ASM Disk (PD_PDDK) record stores performance data indicating the status (at a specific point in time) of the ASM disk, which is managed by the ASM instance through which Oracle communicates. This is a multi-instance record.
- Notes
-
-
The collection of ASM Disk (PD_PDDK) records is supported for ASM and Oracle Database if the versions of both are 11.2.0 or later. Collection is not supported in version 11.1.0 or earlier.
-
Group Number becomes 0 and Disk Group Name is blank if no ASM disk group is mounted.
-
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
3600 |
Y |
|
Collection Offset |
260 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PD_PDDK_DISK_NUMBER
-
PD_PDDK_GROUP_NUMBER
Lifetime
From creation to deletion of the ASM disk
Record size
-
Fixed part: 935 bytes
-
Variable part: 773 bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|---|
|
Cold Mbytes Read (COLD_MBYTES_READ) |
Size of data (in MB) read from the cold region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.COLD_BYTES_READ / (1024 * 1024) |
|
Cold Mbytes Written (COLD_MBYTES_WRITTEN) |
Size of data (in MB) written to the cold region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.COLD_BYTES_WRITTEN / (1024 * 1024) |
|
Cold Reads (COLD_READS) |
Number of reads from the cold region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.COLD_READS |
|
Cold Used Mbytes (COLD_USED_MBYTES) |
Size of used area (in MB) in the cold region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.COLD_USED_MB |
|
Cold Writes (COLD_WRITES) |
Number of writes to the cold region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.COLD_WRITES |
|
Create Date (CREATE_DATE) |
Date the disk was added to the disk group |
-- |
string(20) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.CREATE_DATE |
|
Disk Group Name (DISK_GROUP_NAME) |
Name of the group the disk belongs to. The value is blank if the disk does not belong to a group or the disk group is dismounted. |
-- |
string(30) |
No |
Oracle 11g R2 or later |
V$ASM_DISKGROUP.NAME |
|
Disk Name (NAME) |
Disk name |
-- |
string(30) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.NAME |
|
Disk Number (DISK_NUMBER) |
Number assigned to the disk in the disk group |
-- |
ulong |
No |
Oracle 11g R2 or later |
V$ASM_DISK.DISK_NUMBER |
|
Fail Group (FAILGROUP) |
Name of the fail group that includes the disk |
-- |
string(30) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.FAILGROUP |
|
Fail Group Type (FAILGROUP_TYPE) |
Type of fail group |
-- |
string(7) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.FAILGROUP_TYPE |
|
Free % (PERCENT_FREE) |
Percentage of unused disk space |
-- |
double |
No |
Oracle 11g R2 or later |
(V$ASM_DISK.FREE_MB / V$ASM_DISK.TOTAL_MB) * 100 |
|
Free Mbytes (FREE_MBYTES) |
Size of unused disk space (in MB) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.FREE_MB |
|
Group Number (GROUP_NUMBER) |
Number of the disk group that includes the disk. The value is 0 if the group is dismounted or the disk does not belong to a group. |
-- |
ulong |
No |
Oracle 11g R2 or later |
V$ASM_DISK.GROUP_NUMBER |
|
Header Status (HEADER_STATUS) |
Disk status |
-- |
string(12) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HEADER_STATUS |
|
Hot Mbytes Read (HOT_MBYTES_READ) |
Size of data (in MB) read from the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_BYTES_READ / (1024 * 1024) |
|
Hot Mbytes Written (HOT_MBYTES_WRITTEN) |
Size of data (in MB) written to the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_BYTES_WRITTEN / (1024 * 1024) |
|
Hot Reads (HOT_READS) |
Number of reads from the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_READS |
|
Hot Reads % (PERCENT_HOT_READS) |
Percentage of reads from the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_READS / V$ASM_DISK.READS * 100 |
|
Hot Used % (PERCENT_HOT_USED) |
Percentage of used area in the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
(V$ASM_DISK.HOT_USED_MB / (V$ASM_DISK.HOT_USED_MB + V$ASM_DISK.COLD_USED_MB)) * 100 |
|
Hot Used Mbytes (HOT_USED_MBYTES) |
Size of used area (in MB) in the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_USED_MB |
|
Hot Writes % (PERCENT_HOT_WRITES) |
Percentage of writes to the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_WRITES / V$ASM_DISK.WRITES * 100 |
|
Hot Writes (HOT_WRITES) |
Number of writes to the hot region |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.HOT_WRITES |
|
Label (LABEL) |
Disk label |
-- |
string(31) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.LABEL |
|
Mode Status (MODE_STATUS) |
Global status of the type of I/O request permitted for the disk |
-- |
string(7) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.MODE_STATUS |
|
Mount Date (MOUNT_DATE) |
Date the disk was mounted |
-- |
string(20) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.MOUNT_DATE |
|
Mount Status (MOUNT_STATUS) |
Status of the group the disk belongs to |
-- |
string(7) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.MOUNT_STATUS |
|
OS Mbytes (OS_MBYTES) |
Disk size reported by the OS (in MB) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.OS_MB |
|
Path (PATH) |
OS path |
-- |
string(256) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.PATH |
|
Preferred Read (PREFERRED_READ) |
Status of the preferred read fail group |
-- |
string(1) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.PREFERRED_READ |
|
Read Errs (READ_ERRS) |
Number of I/O read errors for the disk |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.READ_ERRS |
|
Read Mbytes (READ_MBYTES) |
Size of data (in MB) read from the disk |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.BYTES_READ / (1024 * 1024) |
|
Read Time (READ_TIME) |
Total read request time for the disk in seconds. Set the TIMED_STATISTICS parameter in the init.ora file to TRUE to collect the value of this field. |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.READ_TIME |
|
Reads (READS) |
Number of I/O read requests for the disk |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.READS |
|
Record Time (RECORD_TIME) |
Time that collection of the performance data stored in the record finished |
-- |
time_t |
No |
Oracle 11g R2 or later |
Remote Monitor Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record name. Always set to PDDK. |
-- |
string(4) |
No |
Oracle 11g R2 or later |
Remote Monitor Collector |
|
Redundancy (REDUNDANCY) |
Hardware redundancy of the disk |
-- |
string(7) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.REDUNDANCY |
|
Repair Timer (REPAIR_TIMER) |
Remaining time until the disk is automatically deleted |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.REPAIR_TIMER |
|
Sector Size (SECTOR_SIZE) |
Physical block size in bytes |
-- |
ushort |
No |
Oracle 11g R2 or later |
V$ASM_DISK.SECTOR_SIZE |
|
Start Time (START_TIME) |
Start time for collection of the performance data stored in the record |
-- |
time_t |
No |
Oracle 11g R2 or later |
Remote Monitor Collector |
|
State (STATE) |
Global status of the disk in relation to the disk group |
-- |
string(8) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.STATE |
|
Total Mbytes (TOTAL_MBYTES) |
Total disk capacity (in MB) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.TOTAL_MB |
|
UDID (UDID) |
Unique device ID in the name returned by detection |
-- |
string(64) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.UDID |
|
Used Mbytes (USED_MBYTES) |
Size of used disk space (in MB) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.TOTAL_MB - V$ASM_DISK.FREE_MB |
|
VA DeviceID (VADEVICEID) |
Device ID of the virtual agent |
-- |
string(256) |
No |
Oracle 11g R2 or later |
Remote Monitor Collector |
|
Voting File (VOTING_FILE) |
Indicates whether a voting file is included in the disk. Y is set if the voting file is included. In other cases, N is set. |
-- |
string(1) |
No |
Oracle 11g R2 or later |
V$ASM_DISK.VOTING_FILE |
|
Write Errs (WRITE_ERRS) |
Number of disk write errors |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.WRITE_ERRS |
|
Write Time (WRITE_TIME) |
Total write request time to the disk in seconds. Set the TIMED_STATISTICS parameter in the init.ora file to TRUE to collect the value of this field. |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.WRITE_TIME |
|
Writes (WRITES) |
Number of I/O write requests to the disk |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.WRITES |
|
Written Mbytes (WRITTEN_MBYTES) |
Size of data written to the disk (in MB) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.BYTES_WRITTEN / (1024 * 1024) |