| Previous | Table of Contents | Next |
Listing 11.2 shows you the output of the snapshot script.
Listing 11.2 The output of snapshot.sql.
SQL> @snapshot
**********************************************************************
Hit Ratio Section
**********************************************************************
=========================
BUFFER HIT RATIO
=========================
(should be > 70, else increase db_block_buffers in init.ora)
logical_reads phys_reads phy_writes BUFFER HIT RATIO
-------------- ------------ ------------ ----------------
46,961,377 2,194,393 154,145 95
=========================
DATA DICT HIT RATIO
=========================
(should be higher than 90 else increase shared_pool_size in init.ora)
Data Dict. Gets Data Dict. cache misses DATA DICT CACHE HIT RATIO
--------------- ----------------------- -------------------------
380,780 13,797 96
=========================
LIBRARY CACHE MISS RATIO
=========================
(If > 1 then increase the shared_pool_size in init.ora)
executions Cache misses while executing LIBRARY CACHE MISS RATIO
------------ ---------------------------- ------------------------
380,971 2,437 .0064
=========================
Library Cache Section
=========================
hit ratio should be > 70, and pin ratio > 70 ...
NAMESPACE Hit ratio pin hit ratio reloads
-------------- ---------- ------------- ------------
SQL AREA 95 97 1,253
TABLE/PROCEDURE 88 93 1,174
BODY 98 97 10
TRIGGER 50 50 0
INDEX 3 31 0
CLUSTER 44 33 0
OBJECT 100 100 0
PIPE 100 100 0
=========================
REDO LOG BUFFER
=========================
(should be near 0, else increase size of LOG_BUFFER in init.ora)
redo log space requests 29
*****************************************************************
Free memory should be > 1,000
*****************************************************************
NAME BYTES
-------------------------- ------------
free memory 54,820
*****************************************************************
SQL Summary Section
*****************************************************************
Tot SQL run since startup SQL executing now
------------------------- -----------------
60,390 2
**********************************************************************
Lock Section
**********************************************************************
=========================
SYSTEM-WIDE LOCKS - all requests for locks or latches
=========================
User Lock Type Mode Held
------------ ------------------ ------------------
OPS$G449488 DML Exclusive
DATAPUMP PL/SQL User Lock Share
=========================
DDL LOCKS - These are usually triggers or other DDL
=========================
User Owner Name Type Mode held
------------ ------- ---------------- --------------- ---------
OPS$G241107 GENESIS VALID_DOMAIN_VA Table/Procedure Null
OPS$G499058 GENESIS REB0004_PKG Body Null
OPS$G499058 GENESIS REB0004_PKG Table/Procedure Null
OPS$G241107 SYS DBMS_STANDARD Body Null
OPS$G499058 GENESIS INSERT_REBPGMCH Table/Procedure Null
OPS$G499058 GENESIS INSERT_REBPGMCH Table/Procedure Null
=========================
DML LOCKS - These are table and row locks
=========================
********************************************************************
Latch Section
********************************************************************
if miss_ratio or immediate_miss_ratio > 1 then latch
contention exists, decrease LOG_SMALL_ENTRY_MAX_SIZE in init.ora
NAME miss_ratio immediate_miss_ratio
------------------------------ ---------- --------------------
cache buffers lru chain #### .59
redo copy #### .01
*******************************************************************
Rollback Segment Section
*******************************************************************
if any count below is > 1% of the total number of requests for data
then more rollback segments are needed
if free list > 1% then increase FREELIST in init.ora
CLASS COUNT
------------------ ----------
free list 0
system undo block 0
system undo header 0
undo block 0
undo header 6
Tot # of Requests for Data
--------------------------
46,961,805
=========================
ROLLBACK SEGMENT CONTENTION
=========================
If any ratio is > .01 then more rollback segments are needed
NAME WAITS GETS Ratio
------------------------------ ---------- ---------- --------
SYSTEM 0 1431 0.00000
ROLB1 0 10808 0.00000
ROLB2 0 11225 0.00000
ROLB3 0 11832 0.00000
ROLB4 0 9976 0.00000
*******************************************************************
Session Event Section
*******************************************************************
if average-wait > 0 then contention exists
no rows selected
*******************************************************************
Queue Section
*******************************************************************
average wait for queues should be near zero ...
no rows selected
*******************************************************************
Multi-threaded Server Section
*******************************************************************
=========================
Dispatcher Usage
=========================
| Previous | Table of Contents | Next |