Databases Reference
In-Depth Information
Table 25-3.
Oracle10g Statspack Repository Tables (Continued)
Statspack Table
Underlying V$ View(s)
Purpose
STATS$SQL_STATISTICS
V$SQL
Memory consumption by all SQL
statements and non-sharable SQL
statements
STATS$SQL_SUMMARY
V$SQLSTATS
Performance metrics, such as elapsed
time, CPU usage, disk reads, direct
path writes, and buffer gets for
captured SQL statements
STATS$SQL_WORKAREA_HISTOGRAM
V$SQL_WORKAREA_HISTOGRAM
Histogram statistics for work area
sizes of 0-1 KB, 1-2 KB, 2-4 KB,
4-8 KB, etc.
STATS$STATSPACK_PARAMETER
n/a
Statspack parameters such as default
snapshot level and thresholds
STATS$STREAMS_APPLY_SUM
V$STREAMS_APPLY_SERVER
,
V$STREAMS_APPLY_READER
Statistics for Streams apply processes
STATS$STREAMS_CAPTURE
V$STREAMS_CAPTURE
Statistics for Streams capture
STATS$STREAMS_POOL_ADVICE
V$STREAMS_POOL_ADVICE
Streams pool sizing advice
(parameter
STREAMS_POOL_SIZE
)
STATS$SYSSTAT
V$SYSSTAT
Instance-wide statistics, such as
total CPU consumption, recursive
CPU usage, parse calls (hard/total),
number of transactions, etc.
STATS$SYSTEM_EVENT
V$SYSTEM_EVENT
Instance-wide wait event statistics
STATS$SYS_TIME_MODEL
V$SYS_TIME_MODEL
Instance-wide time model statistics
STATS$TEMPSTATXS
V$TABLESPACE
,
V$TEMPFILE
,
V$TEMPSTAT
,
X$KCBFWAIT
Statistics on sorting in temporary
segments
STATS$TEMP_HISTOGRAM
V$TEMP_HISTOGRAM
Histogram statistics on the number
of single block read operations from
temporary segments in buckets of
0-1, 1-2, 2-4, 4-8, 8-16, etc. milli-
seconds read duration
STATS$THREAD
V$THREAD
Information on online redo
log threads
STATS$TIME_MODEL_STATNAME
V$SYS_TIME_MODEL
Lookup table for the column
STAT_ID
in the tables
STATS$SYS_TIME_MODEL
and
STATS$SESS_TIME_MODEL
STATS$UNDOSTAT
V$UNDOSTAT
Undo segment statistics
STATS$WAITSTAT
V$WAITSTAT
Block contention statistics for data
blocks, extent maps, file header
blocks, free lists, undo blocks, undo
headers, etc.
