Databases Reference
In-Depth Information
Table 25-3.
Oracle10g Statspack Repository Tables (Continued)
Statspack Table
Underlying V$ View(s)
Purpose
STATS$RESOURCE_LIMIT
V$RESOURCE_LIMIT
Resource limit statistics on processes,
sessions, enqueues, parallel execu-
tion, and undo (or rollback) segments
STATS$ROLLSTAT
V$ROLLSTAT
Rollback segment statistics
STATS$ROWCACHE_SUMMARY
V$ROWCACHE
Data dictionary cache (a.k.a. row
cache) statistics per category (e.g.,
segments, sequences, and users)
STATS$RULE_SET
V$RULE_SET
Statistics on rule set evaluations
STATS$SEG_STAT
V$SEGMENT_STATISTICS
Segments with high physical reads
or contention including RAC-specific
statistics
STATS$SEG_STAT_OBJ
V$SEGMENT_STATISTICS
Lookup table for the columns
DATAOBJ#
,
OBJ#
and
TS#
in
STATS$SEG_STAT
STATS$SESSION_EVENT
V$SESSION_EVENT
Statistics on session-specific wait
events
STATS$SESSTAT
V$SESSTAT
Session-specific statistics captured
if the parameter
I_SESSION_ID
was
used with
STATSPACK.SNAP
STATS$SESS_TIME_MODEL
V$SESS_TIME_MODEL
Session-specific time model statistics
STATS$SGA
V$SGA
SGA sizing information pertaining
to these SGA components: database
buffers, redo buffers, variable size,
and fixed size
STATS$SGASTAT
V$SGASTAT
Statistics on individual pools and
free memory in the shared pool
STATS$SGA_TARGET_ADVICE
V$SGA_TARGET_ADVICE
SGA sizing advice if Automatic SGA
Memory Management is enabled
(parameter
SGA_TARGET
)
STATS$SHARED_POOL_ADVICE
V$SHARED_POOL_ADVICE
Shared pool sizing advice
STATS$SNAPSHOT
V$INSTANCE
,
V$SESSION
Stores detailed data on each
snapshot, such as snapshot ID,
instance number, startup time,
snapshot level, session ID passed
to
STATSPACK.SNAP
with parameter
I_SESSION_ID
, comment, and
thresholds
STATS$SQLTEXT
V$SQLTEXT
Normalized SQL statement texts split
into pieces of at most 64 characters
STATS$SQL_PLAN
V$SQL_PLAN
Execution plans of captured SQL
statements
STATS$SQL_PLAN_USAGE
V$SQL_PLAN
Snapshot ID, date, and time when
an execution plan was used