Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: outline not working on 1 instance of RAC cluster

RE: outline not working on 1 instance of RAC cluster

From: Pal, Raj <Raj.Pal_at_echostar.com>
Date: Fri, 13 Apr 2007 17:02:21 -0600
Message-ID: <9B03F5DB6F5FAB42B13504933E0070AC08CE0345@MER2-EXCHB3.echostar.com>


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
Received on Fri Apr 13 2007 - 18:02:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US