PATH_ID |
NUMBER |
|
ID of the stream path |
COMPONENT_ID |
NUMBER |
|
ID of the bottleneck component |
COMPONENT_NAME |
VARCHAR2(4000) |
|
Name of the bottleneck component |
COMPONENT_DB |
VARCHAR2(128) |
|
Database where the bottleneck component resides |
COMPONENT_TYPE |
VARCHAR2(20) |
|
Type of the bottleneck component:
-
CAPTURE
-
PROPAGATION SENDER
-
PROPAGATION RECEIVER
-
APPLY
-
QUEUE
|
TOP_SESSION_ID |
NUMBER |
|
ID of the top session for the bottleneck component |
TOP_SESSION_SERIAL# |
NUMBER |
|
Serial number of the top session for the bottleneck component |
ACTION_NAME |
VARCHAR2(32) |
|
Action name for the bottleneck process |
BOTTLENECK_IDENTIFIED |
VARCHAR2(30) |
|
Indicates whether the bottleneck was identified (YES) or not (NO) |
ADVISOR_RUN_ID |
NUMBER |
|
Logical number (1-based) of the Advisor run |
ADVISOR_RUN_TIME |
DATE |
|
Time that the Advisor was run |
ADVISOR_RUN_REASON |
VARCHAR2(4000) |
|
Reason for the bottleneck analysis result.:
-
NULL - Bottleneck is identified
-
PRE-11.1 DATABASE EXISTS - A pre-release 11.1 database exists in the stream path
-
DIAGNOSTIC PACK REQUIRED - A database in the stream path does not have the diagnostic package installed
-
NO BOTTLENECK IDENTIFIED
|
