Errorlog Detail (PD_PDEL)
- Organization of this page
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)
-
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 |
ODBC key fields
-
PD_PDEL_ERROR_TIME
-
PD_PDEL_ERROR_NUM
Lifetime
From the creation to the deletion of an Oracle instance
Record size
-
Fixed part: 678 bytes
-
Variable part: 806 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
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 |