Re: stored outlines set?

From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 17 Nov 2009 19:45:13 +0000 (UTC)
Message-ID: <pan.2009.11.17.19.45.13_at_email.here.invalid>

On Tue, 17 Nov 2009 09:33:55 -0800, sbrjd wrote:

> How can I determine if "alter system set use_stored_outlines.." has been
> issued?
>
> Steven Rosenthal
> databases etc
> Columbia University IT

I don't think you can. The most comprehensive set of the parameters resides in X$KSPPI and there is nothing there:

 SQL> select ksppinm from x$ksppi where ksppinm like '%outl%';

KSPPINM

---

create_stored_outlines
_plan_outline_data
_outline_bitmap_tree

Elapsed: 00:00:00.16
SQL> Maybe, it can be read if you dump SGA but I don't know how to read Oracle dumps.

-- 
http://mgogala.byethost5.com

Received on Tue Nov 17 2009 - 13:45:13 CST