Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: need help on statspack report, Parse CPU to Parse Elapsd %

Re: need help on statspack report, Parse CPU to Parse Elapsd %

From: srivenu <srivenu_at_hotmail.com>
Date: 5 Mar 2004 02:48:36 -0800
Message-ID: <1a68177.0403050248.a6acf5@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US