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.DBA_HIST_SQLSTAT

Object Details

Object Name:	DBA_HIST_SQLSTAT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

SQL Historical Statistics Information

[View Source]

Columns

Name	Datatype	Length	Mandatory
SNAP_ID	NUMBER		Yes
DBID	NUMBER		Yes
INSTANCE_NUMBER	NUMBER		Yes
SQL_ID	VARCHAR2	(13)	Yes
PLAN_HASH_VALUE	NUMBER		Yes
OPTIMIZER_COST	NUMBER
OPTIMIZER_MODE	VARCHAR2	(10)
OPTIMIZER_ENV_HASH_VALUE	NUMBER
SHARABLE_MEM	NUMBER
LOADED_VERSIONS	NUMBER
VERSION_COUNT	NUMBER
MODULE	VARCHAR2	(64)
ACTION	VARCHAR2	(64)
SQL_PROFILE	VARCHAR2	(64)
FORCE_MATCHING_SIGNATURE	NUMBER
PARSING_SCHEMA_ID	NUMBER
PARSING_SCHEMA_NAME	VARCHAR2	(128)
PARSING_USER_ID	NUMBER
FETCHES_TOTAL	NUMBER
FETCHES_DELTA	NUMBER
END_OF_FETCH_COUNT_TOTAL	NUMBER
END_OF_FETCH_COUNT_DELTA	NUMBER
SORTS_TOTAL	NUMBER
SORTS_DELTA	NUMBER
EXECUTIONS_TOTAL	NUMBER
EXECUTIONS_DELTA	NUMBER
PX_SERVERS_EXECS_TOTAL	NUMBER
PX_SERVERS_EXECS_DELTA	NUMBER
LOADS_TOTAL	NUMBER
LOADS_DELTA	NUMBER
INVALIDATIONS_TOTAL	NUMBER
INVALIDATIONS_DELTA	NUMBER
PARSE_CALLS_TOTAL	NUMBER
PARSE_CALLS_DELTA	NUMBER
DISK_READS_TOTAL	NUMBER
DISK_READS_DELTA	NUMBER
BUFFER_GETS_TOTAL	NUMBER
BUFFER_GETS_DELTA	NUMBER
ROWS_PROCESSED_TOTAL	NUMBER
ROWS_PROCESSED_DELTA	NUMBER
CPU_TIME_TOTAL	NUMBER
CPU_TIME_DELTA	NUMBER
ELAPSED_TIME_TOTAL	NUMBER
ELAPSED_TIME_DELTA	NUMBER
IOWAIT_TOTAL	NUMBER
IOWAIT_DELTA	NUMBER
CLWAIT_TOTAL	NUMBER
CLWAIT_DELTA	NUMBER
APWAIT_TOTAL	NUMBER
APWAIT_DELTA	NUMBER
CCWAIT_TOTAL	NUMBER
CCWAIT_DELTA	NUMBER
DIRECT_WRITES_TOTAL	NUMBER
DIRECT_WRITES_DELTA	NUMBER
PLSEXEC_TIME_TOTAL	NUMBER
PLSEXEC_TIME_DELTA	NUMBER
JAVEXEC_TIME_TOTAL	NUMBER
JAVEXEC_TIME_DELTA	NUMBER
IO_OFFLOAD_ELIG_BYTES_TOTAL	NUMBER
IO_OFFLOAD_ELIG_BYTES_DELTA	NUMBER
IO_INTERCONNECT_BYTES_TOTAL	NUMBER
IO_INTERCONNECT_BYTES_DELTA	NUMBER
PHYSICAL_READ_REQUESTS_TOTAL	NUMBER
PHYSICAL_READ_REQUESTS_DELTA	NUMBER
PHYSICAL_READ_BYTES_TOTAL	NUMBER
PHYSICAL_READ_BYTES_DELTA	NUMBER
PHYSICAL_WRITE_REQUESTS_TOTAL	NUMBER
PHYSICAL_WRITE_REQUESTS_DELTA	NUMBER
PHYSICAL_WRITE_BYTES_TOTAL	NUMBER
PHYSICAL_WRITE_BYTES_DELTA	NUMBER
OPTIMIZED_PHYSICAL_READS_TOTAL	NUMBER
OPTIMIZED_PHYSICAL_READS_DELTA	NUMBER
CELL_UNCOMPRESSED_BYTES_TOTAL	NUMBER
CELL_UNCOMPRESSED_BYTES_DELTA	NUMBER
IO_OFFLOAD_RETURN_BYTES_TOTAL	NUMBER
IO_OFFLOAD_RETURN_BYTES_DELTA	NUMBER
BIND_DATA	RAW	(2000)
FLAG	NUMBER
CON_DBID	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      SQL_ID
,      PLAN_HASH_VALUE
,      OPTIMIZER_COST
,      OPTIMIZER_MODE
,      OPTIMIZER_ENV_HASH_VALUE
,      SHARABLE_MEM
,      LOADED_VERSIONS
,      VERSION_COUNT
,      MODULE
,      ACTION
,      SQL_PROFILE
,      FORCE_MATCHING_SIGNATURE
,      PARSING_SCHEMA_ID
,      PARSING_SCHEMA_NAME
,      PARSING_USER_ID
,      FETCHES_TOTAL
,      FETCHES_DELTA
,      END_OF_FETCH_COUNT_TOTAL
,      END_OF_FETCH_COUNT_DELTA
,      SORTS_TOTAL
,      SORTS_DELTA
,      EXECUTIONS_TOTAL
,      EXECUTIONS_DELTA
,      PX_SERVERS_EXECS_TOTAL
,      PX_SERVERS_EXECS_DELTA
,      LOADS_TOTAL
,      LOADS_DELTA
,      INVALIDATIONS_TOTAL
,      INVALIDATIONS_DELTA
,      PARSE_CALLS_TOTAL
,      PARSE_CALLS_DELTA
,      DISK_READS_TOTAL
,      DISK_READS_DELTA
,      BUFFER_GETS_TOTAL
,      BUFFER_GETS_DELTA
,      ROWS_PROCESSED_TOTAL
,      ROWS_PROCESSED_DELTA
,      CPU_TIME_TOTAL
,      CPU_TIME_DELTA
,      ELAPSED_TIME_TOTAL
,      ELAPSED_TIME_DELTA
,      IOWAIT_TOTAL
,      IOWAIT_DELTA
,      CLWAIT_TOTAL
,      CLWAIT_DELTA
,      APWAIT_TOTAL
,      APWAIT_DELTA
,      CCWAIT_TOTAL
,      CCWAIT_DELTA
,      DIRECT_WRITES_TOTAL
,      DIRECT_WRITES_DELTA
,      PLSEXEC_TIME_TOTAL
,      PLSEXEC_TIME_DELTA
,      JAVEXEC_TIME_TOTAL
,      JAVEXEC_TIME_DELTA
,      IO_OFFLOAD_ELIG_BYTES_TOTAL
,      IO_OFFLOAD_ELIG_BYTES_DELTA
,      IO_INTERCONNECT_BYTES_TOTAL
,      IO_INTERCONNECT_BYTES_DELTA
,      PHYSICAL_READ_REQUESTS_TOTAL
,      PHYSICAL_READ_REQUESTS_DELTA
,      PHYSICAL_READ_BYTES_TOTAL
,      PHYSICAL_READ_BYTES_DELTA
,      PHYSICAL_WRITE_REQUESTS_TOTAL
,      PHYSICAL_WRITE_REQUESTS_DELTA
,      PHYSICAL_WRITE_BYTES_TOTAL
,      PHYSICAL_WRITE_BYTES_DELTA
,      OPTIMIZED_PHYSICAL_READS_TOTAL
,      OPTIMIZED_PHYSICAL_READS_DELTA
,      CELL_UNCOMPRESSED_BYTES_TOTAL
,      CELL_UNCOMPRESSED_BYTES_DELTA
,      IO_OFFLOAD_RETURN_BYTES_TOTAL
,      IO_OFFLOAD_RETURN_BYTES_DELTA
,      BIND_DATA
,      FLAG
,      CON_DBID
,      CON_ID
FROM SYS.DBA_HIST_SQLSTAT;

Dependencies

[top of page]

SYS.DBA_HIST_SQLSTAT references the following:

SYS: INT$DBA_HIST_SQLSTAT

SYS.DBA_HIST_SQLSTAT is referenced by following:

PUBLIC: DBA_HIST_SQLSTAT
SYS: DBMS_SQLTCB_INTERNAL - show dependent code; DBMS_SQLTUNE - show dependent code; DBMS_SWRF_REPORT_INTERNAL - show dependent code