Oracle 视图 DBA_STREAMS_TP_PATH_BOTTLENECK 官方解释，作用，如何使用详细说明

本站中文解释

_STATUSA

Oracle视图DBA_STREAMS_TP_PATH_BOTTLENECK_STATUS表明Streams传输过程(TP)管道的瓶颈情况，包括从源到目标的每一步管道的消息处理能力以及当前管道处理过程中发现的明显瓶颈点。

使用方法：

1、查询所有传输过程管道瓶颈情况：

SELECT * FROM DBA_STREAMS_TP_PATH_BOTTLENECK_STATUS;

2、查看指定传输过程管道的瓶颈情况：

SELECT * FROM DBA_STREAMS_TP_PATH_BOTTLENEC, WHERE NAME = ”;

3、查询指定传输过程名称及瓶颈信息：

SELECT NAME,\BOTTLENECK_TYPE, BOTTLENECK_DETAILS, BOTTLENECK_REMEDY, BOTTLENECK_SOLUTION
FROM DBA_STREAMS_TP_PATH_BOTTLENEC WHERE NAME = ”;

官方英文解释

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

Column	Datatype	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(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`