1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
  4. V$DIAG_INCIDENT

7.171 V$DIAG_INCIDENT

V$DIAG_INCIDENT contains information about all incident 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)

The path to the current ADR home

INCIDENT_ID

NUMBER

ID for the current incident

PROBLEM_ID

NUMBER

ID for the problem that the incident is associated with

CREATE_TIME

TIMESTAMP(9) WITH TIME ZONE

Displays the date and time when the incident was created

CLOSE_TIME

TIMESTAMP(9) WITH TIME ZONE

Displays the date and time when the incident was closed

STATUS

NUMBER

Describes the current status for the incident. Possible values include:

  • 1: Incident is inflight

  • 2: Incident is ready

  • 3: Incident is tracked

  • 4: Incident is closed

  • 5: Incident data is removed

  • 6: Incident has been purged

  • 7: Incident is incomplete

FLAGS

NUMBER

For internal use only

FLOOD_CONTROLLED

NUMBER

Describes the flood control status for the current incident. Possible values include:

  • 0: Incident is not flood-controlled

  • 1: Incident is fully flood controlled (no dumps)

ERROR_FACILITY

VARCHAR2(12)

Displays the error facility for the current incident

ERROR_NUMBER

NUMBER

Displays the error number for the current incident

ERROR_ARG1

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG2

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG3

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG4

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG5

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG6

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG7

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG8

VARCHAR2(66)

Displays error-arguments associated with the given incident

SIGNALLING_COMPONENT

VARCHAR2(66)

Signalling component for the given incident

SIGNALLING_SUBCOMPONENT

VARCHAR2(66)

Signalling sub-component for the given incident

SUSPECT_COMPONENT

VARCHAR2(66)

Displays the suspect component for the given incident

SUSPECT_SUBCOMPONENT

VARCHAR2(66)

Displays the suspect sub-component for the given incident

ECID

VARCHAR2(66)

Execution context ID for the current incident

IMPACT

NUMBER

Describes the internal representation of the incident impact for the given incident

ERROR_ARG9

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG10

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG11

VARCHAR2(66)

Displays error-arguments associated with the given incident

ERROR_ARG12

VARCHAR2(66)

Displays error-arguments associated with the given incident

CON_UID

NUMBER

Describes the container unique ID to which the data pertains