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]

TABLE: SYS.WRH$_SQLSTAT

Object Details

Object Name:	WRH$_SQLSTAT
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Primary Key: WRH$_SQLSTAT_PK

DBID
SNAP_ID
INSTANCE_NUMBER
SQL_ID
PLAN_HASH_VALUE
CON_DBID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRH$_SQLSTAT_PK	NORMAL	UNIQUE		DBID SNAP_ID INSTANCE_NUMBER SQL_ID PLAN_HASH_VALUE CON_DBID
WRH$_SQLSTAT_INDEX	NORMAL	NONUNIQUE		SQL_ID DBID CON_DBID

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)
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
BIND_DATA	RAW	(2000)
FLAG	NUMBER
PARSING_USER_ID	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
CON_DBID	NUMBER		Yes

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
,      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
,      BIND_DATA
,      FLAG
,      PARSING_USER_ID
,      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
,      CON_DBID
FROM SYS.WRH$_SQLSTAT;

Dependencies

[top of page]

SYS.WRH$_SQLSTAT does not reference any database object

SYS.WRH$_SQLSTAT is referenced by following:

SYS: DBA_HIST_SQLBIND; DBMS_RAT_MASK - show dependent code; DBMS_SQLTUNE_INTERNAL - show dependent code; INT$DBA_HIST_SQLSTAT