Re: catching hard-parsed SQL

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 12 Nov 2004 19:12:21 GMT
Message-ID: <41950af3.333944386@localhost>

If anyone wonders, I just wrong a script that looked for latch contention while happenning, and outputted sql to a file

On Fri, 29 Oct 2004 17:58:29 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Nov 12 2004 - 13:12:21 CST