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

本站中文解释

Oracle视图V$SGA_RESIZE_OPS显示在某一特定的时间点的共享池内存的大小,以及他们的当前尺寸和期望的尺寸。

使用Oracle视图V$SGA_RESIZE_OPS可以帮助DBA查看SGA内存大小的信息,并识别SGA尺寸的异常变化。调整SGA的尺寸可能是为了满足内存使用的期望。从而比较现实和期望的尺寸,以确定内存变动的原因。

使用V$SGA_RESIZE_OPS视图的方法:
1. 执行以下查询语句查看共享池大小:
SELECT current_size, desired_size FROM V$SGA_RESIZE_OPS;
2. 查看当前和期望的SGA尺寸大小比较。
3. 确定SGA尺寸异常变化的原因。

官方英文解释

V$SGA_RESIZE_OPS displays information about the last 800 completed SGA resize operations. This does not include in-progress operations. 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

Requested value of the parameter after the resize

FINAL_SIZE

NUMBER

Real value of the parameter after the resize

STATUS

VARCHAR2(9)

Completion status of the operation:

  • INACTIVE

  • PENDING

  • COMPLETE

  • CANCELLED

  • ERROR

START_TIME

DATE

Start time of the operation

END_TIME

DATE

End time of 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_RESIZE_OPS 官方解释,作用,如何使用详细说明