Errorlog Detail (PD_PDEL)

Function

The Errorlog Detail (PD_PDEL) record stores performance data indicating the status of error messages in the database alert file at a specific point in time. PFM - Agent for Oracle creates one record for each error message. This is a multi-instance record.

The applicable messages begin with one of the following codes:

• DBA-

• EXP-

• IMP-

• LCC-

• OER-

• ORA-

• PCC-

• PLS-

• RTL-

• TNS-

Note:

• If the value of the following initialization parameter for the Oracle database has not been set, you cannot collect this record:

  - For a version earlier than Oracle 11g: background_dump_dest

  - For Oracle 11g or a later version: diagnostic_dest

• If you are collecting this record, do not delete an alert file while PFM - Agent for Oracle is running.

• This record is created for any error message whose first line in the alert file begins with one of the codes indicated above. This record is not created for an error message whose format ends with the code shown below:

  message (ORA-XXXX)

To Page Top

Default and changeable values

Item	Default value	Changeable
Collection Interval	600	Y
Collection Offset	35	Y
Log	No	Y
LOGIF	(Blank)	Y
Over 10 Sec Collection Time	No	N

To Page Top

ODBC key fields

• PD_PDEL_ERROR_TIME

• PD_PDEL_ERROR_NUM

To Page Top

Lifetime

From the creation to the deletion of an Oracle instance

To Page Top

Record size

• Fixed part: 678 bytes

• Variable part: 843 bytes

To Page Top

Fields

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Container (CONTAINER)	The container name and ID of the PDB which an error has been occurred. This field is valid if the monitoring target is Oracle Database 12c R2 or later in a CDB configuration. Otherwise, the value is blank.	--	string(36)	No	Oracle 12c R2 or later	Obtained from the alert files of the database and background process
Error # (ERROR_NUM)	Error number	--	string(10)	No	All	Obtained from the alert files of the database and background process
Error File (ERROR_FILE)	Name of the file resulting in the error. The value of the field is output as an absolute path.	--	string(256)	No	All	Obtained from the alert files of the database and background process
Error Time (ERROR_TIME)	Time the error occurred	--	string(24)	No	All	Obtained from the alert files of the database and background process
Message (MESSAGE)	Error message	--	string(512)	No	All	Obtained from the alert files of the database and background process
Record Time (RECORD_TIME)	Collection termination time for the performance data stored in the record	--	time_t	No	All	Agent Collector
Record Type (INPUT_RECORD_TYPE)	Record name (always PDEL)	--	string(4)	No	All	Agent Collector
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	time_t	No	All	Agent Collector

To Page Top