eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.GV_$AW_CALC

Object Details

Object Name:	GV_$AW_CALC
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SESSION_ID	NUMBER
AGGREGATE_CACHE_HITS	NUMBER
AGGREGATE_CACHE_MISSES	NUMBER
SESSION_CACHE_HITS	NUMBER
SESSION_CACHE_MISSES	NUMBER
POOL_HITS	NUMBER
POOL_MISSES	NUMBER
POOL_NEW_PAGES	NUMBER
POOL_RECLAIMED_PAGES	NUMBER
CACHE_WRITES	NUMBER
POOL_SIZE	NUMBER
CURR_DML_COMMAND	VARCHAR2	(64)
PREV_DML_COMMAND	VARCHAR2	(64)
AGGR_FUNC_LOGICAL_NA	NUMBER
AGGR_FUNC_PRECOMPUTE	NUMBER
AGGR_FUNC_CALCS	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      SESSION_ID
,      AGGREGATE_CACHE_HITS
,      AGGREGATE_CACHE_MISSES
,      SESSION_CACHE_HITS
,      SESSION_CACHE_MISSES
,      POOL_HITS
,      POOL_MISSES
,      POOL_NEW_PAGES
,      POOL_RECLAIMED_PAGES
,      CACHE_WRITES
,      POOL_SIZE
,      CURR_DML_COMMAND
,      PREV_DML_COMMAND
,      AGGR_FUNC_LOGICAL_NA
,      AGGR_FUNC_PRECOMPUTE
,      AGGR_FUNC_CALCS
,      CON_ID
FROM SYS.GV_$AW_CALC;

Dependencies

[top of page]

SYS.GV_$AW_CALC references the following:

SYS.GV_$AW_CALC is referenced by following:

PUBLIC: GV$AW_CALC