Database Summary Information

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
---------- ----------- ------------ --------   -----------  ------------
GLOB         188430914   glob              1  9.2.0.4.0   NO    b02

Snapshot Duration and Sampling Details

            Snap Id     Snap Time      Sessions Curs/Sess Comment
            ------- ------------------ -------- --------- -------------------
Begin Snap:   508    10-Nov-03 15:27:29       76      39.4
End Snap:     511    10-Nov-03 15:57:42       66      35.4
   Elapsed:                               30.22 (mins)

Critical Performacne Ratios

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %: 100.00
            Buffer  Hit   %:   99.81    In-memory Sort %: 100.00
            Library Hit   %:   98.75        Soft Parse %:  97.05
         Execute to Parse %:   44.21         Latch Hit %:  94.79
Parse CPU to Parse Elapsd %:   11.74     % Non-Parse CPU:  96.08

Execute to Parse Ratio Calculation

Formula:

100 * (1 - Parses/Executions)

Using sample statistics:

parse count (total): 2,718,643
execute count: 4,873,158

Computation:

100 * (1 - 2,718,643 / 4,873,158) = 44.21%

Values below 0 indicate excessive reparsing and potential shared pool issues.

Parse CPU to Parse Elapsed Ratio

Formula:

100 * (parse time cpu / parse time elapsed)

Sample values:

parse time cpu: 44,009
parse time elapsed: 374,902

Computation:

100 * (44,009 / 374,902) = 11.74%

Rollback per Transaction Percentage

Formula:

ROUND(user_rollbacks / (user_commits + user_rollbacks), 4) * 100

Sample statistics:

user commits: 31,910
user rollbacks: 19,740

Computation:

ROUND(19,740 / (31,910 + 19,740), 4) * 100 = 38.22%

High rollback rates indicate transactional inefficiencies and potential undo segment contention.