Oracle教程

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

本站中文解释

Oracle中V$SHARED_POOL_RESERVED视图包含了与Shared Pool子池和保留大小（如果设置的话）的数据。它显示了所有Shared Pool子池的设置，其中包括它们的保留大小、可使用的大小以及实际占用的大小。可以用该视图来监控Shared Pool子池的大小，以确保它们有足够的空间来维护其中的对象。

可以使用V$SHARED_POOL_RESERVED视图查询指定Shared Pool子池的性能数据，以及它们是否有足够的空间来存储对象，以及这些对象是否能够得到充分利用。要使用这个视图，可以使用下面的SQL语句：

SELECT * FROM V$SHARED_POOL_RESERVED;

官方英文解释

V$SHARED_POOL_RESERVED displays statistics that help you tune the reserved pool and space within the shared pool.

Column Datatype Description

FREE_SPACE

NUMBER

Total amount of free space on the reserved list in bytesFoot 1

AVG_FREE_SIZE

NUMBER

Average size of the free memory on the reserved list in bytesFoot 1

FREE_COUNT

NUMBER

Number of free pieces of memory on the reserved listFoot 1

MAX_FREE_SIZE

NUMBER

Size of the largest free piece of memory on the reserved list in bytesFoot 1

USED_SPACE

NUMBER

Total amount of used memory on the reserved list in bytesFoot 1

AVG_USED_SIZE

NUMBER

Average size of the used memory on the reserved list in bytesFoot 1

USED_COUNT

NUMBER

Number of used pieces of memory on the reserved listFoot 1

MAX_USED_SIZE

NUMBER

Size of the largest used piece of memory on the reserved list in bytesFoot 1

REQUESTS

NUMBER

Number of times that the reserved list was searched for a free piece of memoryFoot 1

REQUEST_MISSES

NUMBER

Number of times the reserved list did not have a free piece of memory to satisfy the request, and started flushing objects from the LRU listFoot 1

LAST_MISS_SIZE

NUMBER

Request size of the last request miss in bytes, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU listFoot 1

MAX_MISS_SIZE

NUMBER

Request size of the largest request miss in bytes, when the reserved list did not have a free piece of memory to satisfy the request and started flushing objects from the LRU listFoot 1

REQUEST_FAILURES

NUMBER

Number of times that no memory was found to satisfy a request. If an internal flush (used to free up memory) does not meet a memory need, then the error ORA-04031 occurs.Foot 2

LAST_FAILURE_SIZE

NUMBER

Request size of the last failed request in bytes. If an internal flush (used to free up memory) does not meet a memory need, then the error ORA-04031 occurs.Foot 2

ABORTED_REQUEST_THRESHOLD

NUMBER

Minimum size of a request in bytes which signals an ORA-04031 error without flushing objectsFoot 2

ABORTED_REQUESTS

NUMBER

Number of requests that signalled an ORA-04031 error without flushing objectsFoot 2

LAST_ABORTED_SIZE

NUMBER

Last size of the request in bytes that returned an ORA-04031 error without flushing objects from the LRU listFoot 2

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

These columns are valid only if the initialization parameter SHARED_POOL_RESERVED_SIZE is set to a valid value.

Footnote 2

These columns contain values which are valid even if SHARED_POOL_RESERVED_SIZE is not set.


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

相关推荐