RE: outline not working on 1 instance of RAC cluster
- From: Wayne Adams <work@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, "Tony Aponte" <Tony_Aponte@xxxxxxxxx>, "Pal, Raj" <Raj.Pal@xxxxxxxxxxxx>
- Date: Fri, 13 Apr 2007 16:33:10 -0700
Ok, I did the oradebug, and low and behold, the values were 0s. Turns out the
instance was bounced yesterday.
So, this implies that enabled outlines don't survive an instance bounce. On the
surface, this makes sense, since it is an "alter system" command that enables
it,
but apparently, you can't set this in the spfile.
SQL> ALTER SYSTEM SET USE_STORED_OUTLINES = STEVE_OUTL scope=spfile sid='*';
ALTER SYSTEM SET USE_STORED_OUTLINES = STEVE_OUTL scope=spfile sid='*'
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
So, how do you make an outline persistent? Do you have to issue the alter
system
in the database startup trigger?
And while we're talking about it, there's got to be an easier way to see whether
an outline is active?
Wayne
On Fri Apr 13 17:02 , "Pal, Raj" sent:
>RE: outline not working on 1 instance of RAC cluster
>
>
>To check for sure, try this:
>
>SQL> oradebug setmypid
>
>SQL> oradebug dumpvar sga sgauso 100
>
> -If 2nd & 3rd set of (8) numbers are != 0, then use_stored_outlines=true.
>
> (Eg. qolprm sgauso_ [700000010020F58, 700000010020F7C) = 00000001
00074445 4641554C 54000000 00000000 00000000 00000000 00000000 00000000)
>
> -If both 2nd & 3rd sets are all 0sâ?¦ use_stored_outlines=false.
>
> (Eg. qolprm sgauso_ [700000010020F58, 700000010020F7C) = 00000000
00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000)
>
>But the best way is just to "alter system set use_stored_outlines = true;"
anyway. Altering the system again if you are expecting it to be on should not
cause an issue.
>
>Raj.
>
>
>
>-----Original Message-----
>
>From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Wayne Adams
>
>Sent: Friday, April 13, 2007 4:27 PM
>
>To: oracle-l@xxxxxxxxxxxxx; Tony Aponte
>
>Subject: RE: outline not working on 1 instance of RAC cluster
>
>Yes (as far as I know). I was thinking about that when I was writing up the
>
>problem, but I couldn't figure out how to confirm. I couldn't find a parameter
>
>or V$ view that would tell me for sure.
>
>Wayne
--
//www.freelists.org/webpage/oracle-l
Other related posts:
