Database Reference
In-Depth Information
Table 25-3.
Oracle10g Statspack Repository Tables (Continued)
Statspack Table
Underlying V$ View(s)
Purpose
STATS$INSTANCE_CACHE_TRANSFER
V$INSTANCE_CACHE_TRANSFER
RAC cache transfers
STATS$INSTANCE_RECOVERY
V$INSTANCE_RECOVERY
Statistics on estimated mean time
to recover in case crash recovery is
needed due to instance, operating
system, or hardware failure (param-
eter
FAST_START_MTTR_TARGET
)
STATS$JAVA_POOL_ADVICE
V$JAVA_POOL_ADVICE
Advice for sizing the Java pool
(parameter
JAVA_POOL_SIZE
)
STATS$LATCH
V$LATCH
Latch statistics
STATS$LATCH_CHILDREN
V$LATCH_CHILDREN
Child latch statistics
STATS$LATCH_MISSES_SUMMARY
V$LATCH_MISSES
Latch misses
STATS$LATCH_PARENT
V$LATCH_PARENT
Parent latch statistics
STATS$LEVEL_DESCRIPTION
n/a
Descriptions for snapshot levels 0, 5,
6, 7, and 10
STATS$LIBRARYCACHE
V$LIBRARYCACHE
Shared pool statistics, including RAC
specific statistics
STATS$MUTEX_SLEEP
V$MUTEX_SLEEP
Mutex statistics
STATS$OSSTAT
V$OSSTAT
Operating system statistics, such as
idle time, busy time, I/O wait, and
CPUs in the system
STATS$OSSTATNAME
V$OSSTAT
Lookup table for
STATS$OSSTAT.
OSSTAT_ID
; avoids redundant
storage of
V$OSSTAT.STAT_NAME
STATS$PARAMETER
V$PARAMETER
Captured values of initialization
parameters
STATS$PGASTAT
V$PGASTAT
Program global area (PGA)
statistics for Automatic PGA
Memory Management
STATS$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE
Advice for setting
PGA_AGGREGATE_
TARGET
when using Automatic PGA
Memory Management
STATS$PROCESS_MEMORY_ROLLUP
V$PROCESS_MEMORY
Allocated PGA memory per category
(Freeable, Other, PL/SQL, and SQL)
STATS$PROCESS_ROLLUP
V$PROCESS
Allocated PGA memory per process
STATS$PROPAGATION_RECEIVER
V$PROPAGATION_RECEIVER
Streams buffered queue propaga-
tion statistics on the receiving
(destination) side
STATS$PROPAGATION_SENDER
V$PROPAGATION_SENDER
Streams buffered queue propaga-
tion statistics on the sending
(source) side
