RE: outline not working on 1 instance of RAC cluster
- From: "Pal, Raj" <Raj.Pal@xxxxxxxxxxxx>
- To: <work@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, "Tony Aponte" <Tony_Aponte@xxxxxxxxx>
- Date: Fri, 13 Apr 2007 17:02:21 -0600
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
Other related posts:
