Oracle教程

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

本站中文解释

V$SGA_CURRENT_RESIZE_OPS视图可以查看当前系统的共享池大小调整信息。系统将监控数据库运行，并且根据特定的计算调整共享池大小。因此，通过查询V$SGA_CURRENT_RESIZE_OPS视图，可以查看发生着哪些共享池大小调整，也就是SGA_TARGET参数被修改为多少。

要使用V$SGA_CURRENT_RESIZE_OPS视图，需要先获取相应的DBA权限，然后可以在SQL*Plus中运行SELECT语句来查看表中的数据。

官方英文解释

V$SGA_CURRENT_RESIZE_OPS displays information about SGA resize operations which are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component. All sizes are expressed in bytes.
Column Datatype Description

COMPONENT

VARCHAR2(64)

Component name

OPER_TYPE

VARCHAR2(13)

Operation type:

  • STATIC

  • INITIALIZING

  • DISABLED

  • GROW

  • SHRINK

  • SHRINK_CANCEL

OPER_MODE

VARCHAR2(9)

Operation mode:

  • MANUAL

  • DEFERRED

  • IMMEDIATE

PARAMETER

VARCHAR2(80)

Name of the parameter for the resize operation

INITIAL_SIZE

NUMBER

Parameter value at the start of the operation

TARGET_SIZE

NUMBER

Desired value of the parameter after the resize

CURRENT_SIZE

NUMBER

Current value of the parameter

START_TIME

DATE

Start time of the operation

LAST_UPDATE_TIME

DATE

Last time progress was made for the 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_CURRENT_RESIZE_OPS 官方解释，作用，如何使用详细说明
分享到：

相关推荐