Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_STREAMS_TP_PATH_BOTTLENECK

DBA_STREAMS_TP_PATH_BOTTLENECK displays temporary information about Oracle Streams components that might be slowing down the flow of messages in a stream path.

Column Datatype NULL Description
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