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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wayne Adams Sent: Friday, April 13, 2007 4:27 PM
To: oracle-l_at_freelists.org; 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

--
http://www.freelists.org/webpage/oracle-l