Re: stored outlines set?
Date: Tue, 17 Nov 2009 20:00:25 +0100
> How can I determine if "alter system set use_stored_outlines.." has
> been issued?
> Steven Rosenthal
> databases etc
> Columbia University IT
No way. But the dba_outlines view indicates if an outline has been used. I found it impossible to determine why an outline was not being used. I guess that maybe a plan was already stored in the SGA for a very frequently used query, and a flush shared_pool had no effect until I issued it at a calmer time.
But that was not your question, sorry. Received on Tue Nov 17 2009 - 13:00:25 CST