Re: Trace file Anomolies

From: Matt <mccmx_at_hotmail.com>
Date: 12 Nov 2004 00:09:29 -0800
Message-ID: <cfee5bcf.0411120009.57a16fc2@posting.google.com>

> But add "alter system flush shared_pool;" in another session just
> before exiting (the cursor is open at that point - sqlplus keeps open
> the last cursor and closes it only when another statement is submitted
> or on exit of course) and the STAT line is missing.
>
> My guess is that the (recreatable) chunk(s) containing the plan in the
> library cache got flushed out, and since the STAT lines contain
> nothing more than the plan, they got simply skipped.
>
> If that's correct, all it takes is a stressed library cache (eg no
> bind variables) that is trapped in the vicious loop fill/flush
> partially/fill again/etc and you are very likely to observe missing
> STAT lines.
>

This sounds like a perfectly viable answer - my shared pool is overworked as a result of some SQL using literals so this could very well be the case.

Cheers

Matt Received on Fri Nov 12 2004 - 02:09:29 CST