Re: stored outlines set?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Tue, 17 Nov 2009 11:52:16 -0800 (PST)
Message-ID: <5d4b0270-b641-445a-9f17-1479c8cceb2e_at_o9g2000vbj.googlegroups.com>

On Nov 17, 12:33 pm, sbrjd <s..._at_columbia.edu> wrote:
> How can I determine if "alter system set use_stored_outlines.." has
> been issued?
>
> Steven Rosenthal
> databases etc
> Columbia University IT

Hi Steven,

SQL> oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [060021418, 06002143C) = 00000002 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 SQL> alter system set use_stored_outlines = true;

System altered.

Elapsed: 00:00:00.00
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [060021418, 06002143C) = 00000003 45440007 4C554146 00000054 00000000 00000000 00000000 00000000 00000000 SQL> alter system set use_stored_outlines = false;

System altered.

Elapsed: 00:00:00.00
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [060021418, 06002143C) = 00000004 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 SQL> 00000054 for the fourth value indicates they are enabled at the system level.

HTH, Steve Received on Tue Nov 17 2009 - 13:52:16 CST