Re: catching hard-parsed SQL

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 12 Nov 2004 19:14:32 GMT
Message-ID: <41950b1a.333982942@localhost>

If I wanted to squeeze gigs of db in memory, then I would probably worry about it. My SGAs are under 1G

Thanks.

On Sat, 30 Oct 2004 10:13:19 +1300, Steve <ThisOne_at_Aint.valid> wrote:

>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
>
>Slowlaris 2.7 was a real rush job to get 64 bit support out there in a
>hurry. I seriously recomment that your first tuning exercise be to
>upgrade to 2.8, or better still 2.9, seeing as 10 is now available.
>
>Is your 8.1.7.4 patched up to date?
>
>Sorry to be rather OT on a reply.
>
>Steve

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