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(64)

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