Oracle教程

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


数据运维技术 » Oracle 视图 DBA_STREAMS_TP_PATH_BOTTLENECK 官方解释，作用，如何使用详细说明
分享到：

相关推荐