Re: stored outlines set?

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

On Tue, 17 Nov 2009 11:52:16 -0800, Steve Howard wrote:

> 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

As I said, I am no good at doing dumps....

-- 
http://mgogala.byethost5.com

Received on Tue Nov 17 2009 - 14:09:13 CST