Re: catching hard-parsed SQL

From: Nisar Tareen <ntareen_at_yahoo.com>
Date: 8 Nov 2004 09:24:04 -0800
Message-ID: <6134f1ca.0411080924.5c2e054c@posting.google.com>

Hi,

In my tunning , I had the set the goal for Library Cache contention to be < 1% of Library Cache Missed ratio,

To achive this there are Two things.  

                  1- Increase Share Pool size. ( Easy for DBA to do) 
                  2- Write Identidcal sql  ( Which will decrease
Parsing ,
                                             Need Develpors

involments) .
Good Luck.

Nisar Tareen

netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote in message news:<4182844a.1558041355_at_localhost>...
> Is there are an event that could be set to trace all SQL that's being
> hard parsed?
>
> Trying to increase this #: Soft Parse %: 94.93
> Library Cache contention is a problem during high traffic times.
> Examining v$sql yields little results.
>
> Thanks.
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Mon Nov 08 2004 - 11:24:04 CST