Oracle教程 2023-02-28

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

本站中文解释

Oracle视图DBA_HIST_MEMORY_RESIZE_OPS存储了内存调整操作的历史信息。它可以报告已经完成的内存重组操作，及时跟踪内存调整和内存重组操作对于性能的影响。可以使用该视图查询是何种操作导致内存量调整，查看相应调整操作的执行情况，以及相应的耗时，操作时间，最大内存量，最小内存等信息。该视图可以帮助DBA优化数据库的性能，增强数据库可伸缩性，以满足优化内存大小的变化需求。

使用方法：

1.检查内存调整操作的历史：

SELECT * FROM dba_hist_memory_resize_ops;

2. 查询历史内存重组操作的消耗时间：

SELECT ELAPSED_TIME_DELTA, MAX_SIZE, MIN_SIZE FROM dba_hist_memory_resize_ops;

3. 查询具体内存调整操作信息：

SELECT * FROM dba_hist_memory_resize_ops WHERE OPERATION=’RESIZE’;

官方英文解释

DBA_HIST_MEMORY_RESIZE_OPS displays memory resize operations history.

This view contains snapshots of V$MEMORY_RESIZE_OPS.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`COMPONENT`	`VARCHAR2(64)`	`NOT NULL`	Component name
`OPER_TYPE`	`VARCHAR2(13)`	`NOT NULL`	Operation type: `STATIC` `INITIALIZING` `DISABLED` `GROW` `SHRINK` `SHRINK_CANCEL`
`START_TIME`	`DATE`	`NOT NULL`	Start time of the operation
`END_TIME`	`DATE`	`NOT NULL`	End time of the operation
`TARGET_SIZE`	`NUMBER`	`NOT NULL`	Requested value of the parameter after the resize
`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
`FINAL_SIZE`	`NUMBER`		Real value of the parameter after the resize
`STATUS`	`VARCHAR2(9)`		Completion status of the operation: `INACTIVE` `PENDING` `COMPLETE` `CANCELLED` `ERROR`
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. 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

本站中文解释

官方英文解释

相关推荐