Database Reference
In-Depth Information
Table 25-3. Oracle10g Statspack Repository Tables
Statspack Table
Underlying V$ View(s)
Purpose
STATS$BG_EVENT_SUMMARY
V$SESSION_EVENT
Wait events of background sessions
STATS$BUFFERED_QUEUES
V$BUFFERED_QUEUES
Statistics on Streams buffered queues
(messages processed, messages
spilled to disk, etc.)
STATS$BUFFERED_SUBSCRIBERS
V$BUFFERED_SUBSCRIBERS
Statistics on subscribers of Streams
buffered queues
STATS$BUFFER_POOL_STATISTICS
V$BUFFER_POOL_STATISTICS
Buffer pool statistics per buffer pool
name (DEFAULT, KEEP, RECYCLE)
and block size (2 KB up to 32 KB) in
the database buffer cache
STATS$CR_BLOCK_SERVER
V$CR_BLOCK_SERVER
Statistics concerning RAC consistent
read block server processes (Global
Cache Service)
STATS$CURRENT_BLOCK_SERVER
V$CURRENT_BLOCK_SERVER
Global Cache Service current block
server statistics
STATS$DATABASE_INSTANCE
V$INSTANCE
DBMS instances for which Statspack
has captured snapshots
STATS$DB_CACHE_ADVICE
V$DB_CACHE_ADVICE
Sizing advice for the database buffer
cache per buffer pool name and
block size
STATS$DLM_MISC
V$DLM_MISC
Real Application Clusters Global
Enqueue Service and Global Cache
Service statistics
STATS$DYNAMIC_REMASTER_STATS
X$KJDRMAFNSTATS
RAC Global Cache Service resource
remastering
STATS$ENQUEUE_STATISTICS
V$ENQUEUE_STATISTICS
Enqueue statistics
STATS$EVENT_HISTOGRAM
V$EVENT_HISTOGRAM
Histogram statistics on wait events
STATS$FILESTATXS
X$KCBFWAIT , V$FILESTAT ,
V$TABLESPACE , V$DATAFILE
I/O statistics per data file
STATS$FILE_HISTOGRAM
V$FILE_HISTOGRAM
Histogram statistics on single block
physical read time; statistics are
reported per file and per read time
range (0-2 ms, 2-4 ms, 4-8 ms, etc.)
STATS$IDLE_EVENT
V$EVENT_NAME
Events considered idle waits
by Statspack 10
10. In Oracle10 g , STATS$IDLE_EVENT contains 41 events from wait class “Idle”, two from wait class “Network”, three
from wait class “Other”, and 24 events which no longer exist in Oracle10 g . STATS$IDLE_EVENT has occasionally
been of concern (see bug database on Metalink), since several releases of Statspack did not insert all the wait
events considered as idle in the table. For example the RAC idle wait event ges remote message was missing in
Oracle9 i . Thus, an idle event could make it into the report section entitled “Top 5 Timed Events” and render the
calculations unusable. The solution consists of inserting missing idle wait events into the table and regenerating
the Statspack report. In Oracle10 g , 21 events from wait class Idle are not registered in STATS$IDLE_EVENT . In my
view, this is rightfully so for the event SQL*Net message from dblink, but PL/SQL lock timer, which occurs when
a session is put to sleep by a call to DBMS_LOCK.SLEEP , should be present in STATS$IDLE_EVENT .
 
Search WWH ::




Custom Search