eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_STREAMS_TP_PATH_BOTTLENECK

Object Details

Object Name:	DBA_STREAMS_TP_PATH_BOTTLENECK
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

DBA Streams Path Bottleneck

[View Source]

Columns

Name	Datatype	Length	Comments
PATH_ID	NUMBER		ID of the Streams Path
COMPONENT_ID	NUMBER
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
TOP_SESSION_ID	NUMBER		ID of the Top Session for the Bottleneck Component
TOP_SESSION_SERIAL#	NUMBER		Serial# of the Top Session for the Bottleneck Component
ACTION_NAME	VARCHAR2	(64)	Action Name for the Bottleneck Process
BOTTLENECK_IDENTIFIED	VARCHAR2	(30)	Whether Bottlecneck Was Identified
ADVISOR_RUN_ID	NUMBER		1-Based Logical Number of Advisor Run
ADVISOR_RUN_TIME	DATE		Time That the Advisor Was Run
ADVISOR_RUN_REASON	VARCHAR2	(4000)	Reasons for Bottleneck Analysis Results

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PATH_ID
,      COMPONENT_ID
,      COMPONENT_NAME
,      COMPONENT_DB
,      COMPONENT_TYPE
,      TOP_SESSION_ID
,      TOP_SESSION_SERIAL#
,      ACTION_NAME
,      BOTTLENECK_IDENTIFIED
,      ADVISOR_RUN_ID
,      ADVISOR_RUN_TIME
,      ADVISOR_RUN_REASON
FROM SYS.DBA_STREAMS_TP_PATH_BOTTLENECK;

Dependencies

[top of page]

SYS.DBA_STREAMS_TP_PATH_BOTTLENECK references the following:

SYS: STREAMS$_COMPONENT; STREAMS$_PATH_BOTTLENECK_OUT

SYS.DBA_STREAMS_TP_PATH_BOTTLENECK is referenced by following:

PUBLIC: DBA_STREAMS_TP_PATH_BOTTLENECK