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: 678 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 |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name. Always set to PDDK. |
-- |
string(4) |
No |
Oracle 11g R2 or later |
Agent 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 |
Agent 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 |
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) |