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.
-
If the monitoring target is Oracle Database 12c Release 2 or later in a CDB configuration, this record stores performance data for all ASM disks in the entire CDB, which are managed by the ASM instances through which Oracle communicates. The retrieved values will be same for both when monitoring PDBs and when monitoring the root container (CDB$ROOT).
-
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 megabytes) 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 megabytes) 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 megabytes) 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 megabytes) |
-- |
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 megabytes) 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 megabytes) 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 megabytes) 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 megabytes) |
-- |
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 megabytes) 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 megabytes) |
-- |
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 megabytes) |
-- |
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 megabytes) |
-- |
double |
No |
Oracle 11g R2 or later |
V$ASM_DISK.BYTES_WRITTEN / (1024 * 1024) |