Re: stored outlines set?

From: Gerard H. Pille <>
Date: Tue, 17 Nov 2009 20:00:25 +0100
Message-ID: <4b02f2c9$0$2850$>

sbrjd wrote:
> 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

Original text of this message