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_$ASH_INFO

Object Details

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

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
TOTAL_SIZE	NUMBER
FIXED_SIZE	NUMBER
SAMPLING_INTERVAL	NUMBER
OLDEST_SAMPLE_ID	NUMBER
OLDEST_SAMPLE_TIME	TIMESTAMP(9)	(20)
LATEST_SAMPLE_ID	NUMBER
LATEST_SAMPLE_TIME	TIMESTAMP(9)	(20)
SAMPLE_COUNT	NUMBER
DROPPED_SAMPLE_COUNT	NUMBER
SAMPLED_BYTES	NUMBER
SAMPLER_ELAPSED_TIME	NUMBER
DISK_FILTER_RATIO	NUMBER
AWR_FLUSH_BYTES	NUMBER
AWR_FLUSH_ELAPSED_TIME	NUMBER
AWR_FLUSH_COUNT	NUMBER
AWR_FLUSH_EMERGENCY_COUNT	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      TOTAL_SIZE
,      FIXED_SIZE
,      SAMPLING_INTERVAL
,      OLDEST_SAMPLE_ID
,      OLDEST_SAMPLE_TIME
,      LATEST_SAMPLE_ID
,      LATEST_SAMPLE_TIME
,      SAMPLE_COUNT
,      DROPPED_SAMPLE_COUNT
,      SAMPLED_BYTES
,      SAMPLER_ELAPSED_TIME
,      DISK_FILTER_RATIO
,      AWR_FLUSH_BYTES
,      AWR_FLUSH_ELAPSED_TIME
,      AWR_FLUSH_COUNT
,      AWR_FLUSH_EMERGENCY_COUNT
,      CON_ID
FROM SYS.GV_$ASH_INFO;

Dependencies

[top of page]

SYS.GV_$ASH_INFO references the following:

SYS.GV_$ASH_INFO is referenced by following:

PUBLIC: GV$ASH_INFO