7.178 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
ADDR	RAW(8)	For internal use only
INDX	NUMBER	For internal use only
INST_ID	NUMBER	For internal use only
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data
ADR_PATH_IDX	VARCHAR2(445)	For internal use only
ADR_HOME	VARCHAR2(445)	Path to the current ADR home
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