Re: stored outlines set?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 17 Nov 2009 20:00:25 +0100
Message-ID: <4b02f2c9$0$2850$ba620e4c_at_news.skynet.be>
sbrjd wrote:
> How can I determine if "alter system set use_stored_outlines.." has
> been issued?
>
> Steven Rosenthal
> databases etc
> Columbia University IT
Date: Tue, 17 Nov 2009 20:00:25 +0100
Message-ID: <4b02f2c9$0$2850$ba620e4c_at_news.skynet.be>
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