Oracle教程 2023-04-06

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

本站中文解释

Oracle 视图V$AW_CALC被用来报告着所有当前正在运行的 Automatic Workload Repository (AWR)报告的基本信息。

V$AW_CALC视图具有以下几列：

SNAP_ID: 报告期间的起始SAP映像的ID
INSTANCE_NUMBER: 实例的号码
BEGIN_INTERVAL_TIME: 计算开始时间
END_INTERVAL_TIME: 计算结束时间
AWR_EXPORT_STATUS：表示AWR报告是否被导出了

可以使用V$AW_CALC视图来检查正在运行的AWR报告，可以使用下面的查询查看正在运行的AWR报告。

SELECT snap_id, begin_interval_time, end_interval_time, instance_number
FROM v$aw_calc
WHERE awr_export_status=’RUNNING’;

官方英文解释

V$AW_CALC reports on the effectiveness of various caches used by Oracle OLAP during dynamic aggregation.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	A unique numeric identifier for the session.
`AGGREGATE_CACHE_HITS`	`NUMBER`	The number of times a dimension member is found in the aggregate cache (a hit). The number of hits for run-time aggregation can be increased by fetching data across the dense dimension
`AGGREGATE_CACHE_MISSES`	`NUMBER`	The number of times a dimension member is not found in the aggregate cache and must be read from disk (a miss).
`SESSION_CACHE_HITS`	`NUMBER`	The number of times the data is found in the session cache (a hit).
`SESSION_CACHE_MISSES`	`NUMBER`	The number of times the data is not found in the session cache (a miss).
`POOL_HITS`	`NUMBER`	The number of times the data is found in a page in the OLAP page pool (a hit).
`POOL_MISSES`	`NUMBER`	The number of times the data is not found in the OLAP page pool (a miss).
`POOL_NEW_PAGES`	`NUMBER`	The number of newly created pages in the OLAP page pool that have not yet been written to the workspace LOB.
`POOL_RECLAIMED_PAGES`	`NUMBER`	The number of previously unused pages that have been recycled with new data.
`CACHE_WRITES`	`NUMBER`	The number of times the data from the OLAP page pool has been written to the database cache.
`POOL_SIZE`	`NUMBER`	The number of kilobytes in the OLAP page pool.
`CURR_DML_COMMAND`	`VARCHAR2(64)`	The command currently being executed.
`PREV_DML_COMMAND`	`VARCHAR2(64)`	The command most recently completed.
`AGGR_FUNC_LOGICAL_NA`	`NUMBER`	The number of times the aggregation engine returns a logical NA because the AGGINDEX option is on and the composite tuple does not exist.
`AGGR_FUNC_PRECOMPUTE`	`NUMBER`	The number of times the aggregation engine finds a value in a position that it was called to calculate.
`AGGR_FUNC_CALCS`	`NUMBER`	The number of times the aggregation engine calculates a parent value based on the values of its children.
`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$AW_CALC 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐