Oracle教程

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

本站中文解释

Oracle视图V$SGA_DYNAMIC_COMPONENTS提供有关SGA动态组件的信息。SGA是Oracle服务器参数文件(SPFILE)中的参数，用于管理Oracle服务器及其应用程序。SGA是Oracle实例的内存池，其中存储着用于辅助Oracle实例操作的数据结构和数据，如共享池和SQL语句缓存。

V$SGA_DYNAMIC_COMPONENTS显示SGA的动态部件，其中包含锁定在实例的内存的组件的详细信息。每一行表示一个SGA组件，该组件是可以动态更改SGA大小的一个部分。该视图可以帮助你确定SGA大小和结构，如何非永久性地更改它。

要使用V$SGA_DYNAMIC_COMPONENTS，请在SQL*Plus中执行以下查询：

SELECT component, current_size FROM v$sga_dynamic_components;

这将返回SGA组件及其当前大小的列表。

官方英文解释

V$SGA_DYNAMIC_COMPONENTS displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup. All sizes are expressed in bytes.
Column Datatype Description

COMPONENT

VARCHAR2(64)

Component name

CURRENT_SIZE

NUMBER

Current size of the component

MIN_SIZE

NUMBER

Minimum size of the component since instance startup

MAX_SIZE

NUMBER

Maximum size of the component since instance startup

USER_SPECIFIED_SIZE

NUMBER

Value of the user parameter for the component

OPER_COUNT

NUMBER

Number of operations since instance startup

LAST_OPER_TYPE

VARCHAR2(13)

Last completed operation for the component:

  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL

LAST_OPER_MODE

VARCHAR2(9)

Mode of the last completed operation:

  • MANUAL

  • DEFERRED

  • IMMEDIATE

LAST_OPER_TIME

DATE

Start time of the last completed operation

GRANULE_SIZE

NUMBER

Granularity of the grow or the shrink operation

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


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

相关推荐