Oracle教程

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

本站中文解释

V$CURRENT_BLOCK_SERVER 是Oracle数据库中的一个视图。它会显示当前会话块服务器如何运行，对比分析各种参数，从而帮助DBA掌握数据库性能。具体来说，它可以用来查看会话块服务器的状态，包括空闲连接数，会话块丢失次数等。使用这个视图，DBA可以了解block server的数量，以及每个block server的运行情况。

使用V$CURRENT_BLOCK_SERVER视图的步骤如下：

1. 连接到Oracle数据库，使用sys用户或sysdba权限的用户登录。

2. 运行SQL语句：SELECT * FROM V$CURRENT_BLOCK_SERVER;

3. 检查输出中每个列的值，以了解block server的状态。数据库会显示这些信息：block server实例ID，服务器运行状态，空闲连接数，会话块丢失数，block server服务器主机名等等。

4. 根据显示的信息，分析block server的性能，对不正常的性能进行修复，如调整参数和测试block server的加载状态。

官方英文解释

V$CURRENT_BLOCK_SERVER displays statistics on the Global Cache Service processes (LMS) used in cache fusion.

Column Datatype Description

PIN0

NUMBER

Pins taking less than 100 microseconds

PIN1

NUMBER

Pins taking 100 microseconds to 1 millisecond

PIN10

NUMBER

Pins taking 1 to 10 milliseconds

PIN100

NUMBER

Pins taking 10 to 100 milliseconds

PIN1000

NUMBER

Pins taking 100 to 1000 milliseconds

PIN10000

NUMBER

Pins taking 1000 to 10000 milliseconds

FLUSH0

NUMBER

Flushes taking less than 100 microseconds

FLUSH1

NUMBER

Flushes taking 100 microseconds to 1 millisecond

FLUSH10

NUMBER

Flushes taking 1 to 10 milliseconds

FLUSH100

NUMBER

Flushes taking 10 to 100 milliseconds

FLUSH1000

NUMBER

Flushes taking 100 to 1000 milliseconds

FLUSH10000

NUMBER

Flushes taking 1000 to 10000 milliseconds

WRITE1Foot 1

NUMBER

Writes taking less than 1 millisecond

WRITE10Foot 1

NUMBER

Writes taking 1 to 10 milliseconds

WRITE100Foot 1

NUMBER

Writes taking 10 to 100 milliseconds

WRITE1000Foot 1

NUMBER

Writes taking 100 to 1000 milliseconds

WRITE10000Foot 1

NUMBER

Writes taking 1000 to 10000 milliseconds

CLEANDC

NUMBER

Reserved for internal use

RCVDC

NUMBER

Number of lock down-converts to S (shared) caused by instance recovery

QUEUEDC

NUMBER

Number of queued lock down-converts to NULL

EVICTDC

NUMBER

Number of lock down-converts to NULL caused by an SGA shrink

WRITEDC

NUMBER

Number of dirty blocks in read-mostly objects which were written and the X (exclusive) lock down-converted to S (shared) locks

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Footnote 1

This column is deprecated in Oracle Database 12c Release 2 (12.2.0.1) and may be removed in a future release.


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

相关推荐