Joe,
The duration of your statspack (about 9 hrs) is high, normally
Statspack reports are generated for a half-hour duration during peak
load.
Think you are running 8i.
A low value for Parse CPU to Parse Elapsd % means that the during
parsing, the server process is waiting for something, most likely
contending for a latch (shared pool and library cache latches).
But in your case this is not much of a disadvantage as you have a high
% Non-Parse CPU (98.94 %).
You should have also shown the Top 5 Wait Events (Top 5 Timed Events
from 9.2) and the latch information from the statspack.
You also have a high soft parse % - 98.98%.
So most of your parse calls are resulting in soft parses.
In such cases, the setting of SESSION_CACHED_CURSORS parameter helps
(you can start with a value of 150).
You may also want to look at the code, to see why there are so many
parse calls.
Ideally you should parse once and execute many times.
regards
Srivenu
Received on Fri Mar 05 2004 - 04:48:36 CST
