| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Statspack oracle 8.1.7.4.0
Hi
I have ran statspack on a solaris 64, oracle 8i and I see that Soft Parse is low .... We use remote db links between 2 different servers, could this be the problem? since the issue is only in the target database
Load Profile
~~~~~~~~~~~~ Per Second Per
Transaction
---------------
---------------
Redo size: 425,372.98
7,223,314.76
Logical reads: 13,292.32
225,718.63
Block changes: 1,986.09
33,725.99
Physical reads: 2,152.20
36,546.79
Physical writes: 444.96
7,555.92
User calls: 26.32
446.98
Parses: 12.97
220.18
Hard parses: 11.97
203.31
Sorts: 36.10
613.01
Logons: 0.15
2.56
Executes: 940.99
15,979.04
Transactions: 0.06
% Blocks changed per Read: 14.94 Recursive Call %: 98.56
Rollback per transaction %: 0.00 Rows per Sort: 755.55
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 83.81 In-memory Sort %: 99.99
Library Hit %: 70.15 Soft Parse %: 7.66
Execute to Parse %: 98.62 Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 97.42 % Non-Parse CPU: 96.64
Received on Mon Apr 05 2004 - 11:53:21 CDT
![]() |
![]() |