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

本站中文解释

Oracle 视图 V$MEMORY_RESIZE_OPS 显示内存管理器正在执行的操作详细信息,包括组件的增大,缩小,新分配和释放。它显示有关变量的状态,如操作预期的执行时间和结果,COMPONENT_SIZE(组件大小),以及TARGET_SIZE(目标大小)等。

使用 V$MEMORY_RESIZE_OPS 视图可以方便地查看内存管理器正在执行的操作,以及处于何种状态,便于查看内存分配情况。例如,可以使用下面的查询查看内存管理器正在执行的操作:SELECT * FROM V$MEMORY_RESIZE_OPS;

官方英文解释

V$MEMORY_RESIZE_OPS displays information about the last 800 completed memory resize operations (both automatic and manual). 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$MEMORY_RESIZE_OPS 官方解释,作用,如何使用详细说明