Oracle教程 2023-03-28

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

Oracle视图V$MEMORY_CURRENT_RESIZE_OPS是一个性能查询视图,用于显示 SGA 内存重新调整操作的正在处理的操作情况。该视图包括如下内容：

-OP NUM: 表示操作编号；

-PID: 表示操作进程号；

-SIZE CURRENT: 表示当前指定 SGA 区域的大小；

-SIZE REQUESTED: 表示重新调整操作后SGA区域大小设定的目标；

-REQ TYPE: 表示重新调整操作的类型；

-REQ NAME: 表示重新调整操作的名称；

-INTERNAL TYPE: 表示重新调整操作的内部类型；

-INTERNAL STATE: 表示重新调整操作的内部状态。

使用者可以结合其他视图，对此Query进行综合分析，来掌控Oracle数据库的内存资源使用情况。

V$MEMORY_CURRENT_RESIZE_OPS displays information about memory resize operations (both automatic and manual) which are currently in progress.

An operation can be a grow or a shrink of a dynamic memory 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

分享到：