V$DIAG_PROBLEM
V$DIAG_PROBLEM contains information about all problem metadata records present in the Automatic Diagnostic Repository (ADR) for the current container (PDB).
| Column | Datatype | Description |
|---|---|---|
PROBLEM_ID |
NUMBER |
Displays the ID for the current problem |
PROBLEM_KEY |
VARCHAR2(552) |
Displays the problem key for the current problem |
FIRST_INCIDENT |
NUMBER |
Displays the first incident ID for the current problem |
FIRSTINC_TIME |
TIMESTAMP(9) WITH TIME ZONE |
Displays the timestamp when the first incident occurred for the current problem |
LAST_INCIDENT |
NUMBER |
Displays the last incident ID for the current problem |
LASTINC_TIME |
TIMESTAMP(9) WITH TIME ZONE |
Displays the timestamp when the last incident occurred for the current problem |
IMPACT1 |
NUMBER |
Displays the first impact for the current problem |
IMPACT2 |
NUMBER |
Displays the second impact for the current problem |
IMPACT3 |
NUMBER |
Displays the third impact for the current problem |
IMPACT4 |
NUMBER |
Displays the fourth impact for the current problem |
SERVICE_REQUEST |
VARCHAR2(66) |
Displays the service request number for the current problem, if a number has been entered in Support Workbench |
BUG_NUMBER |
VARCHAR2(66) |
Displays the bug number for the current problem, if a number has been entered in Support Workbench |
CON_UID |
NUMBER |
Displays the container unique ID to which the data pertains |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|