Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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

Lifetime

From creation to deletion of the ASM disk

Record size

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

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 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

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)