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

网络编程 Oracle 视图 V$SGA_RESIZE_OPS 官方解释，作用，如何使用详细说明 10-18

本站中文解释

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

编辑：568数据

标签：尺寸,视图,大小,内存,异常