RE: Why is USE_STORED_OUTLINES not an initialization parameter?
- From: "ramick" <ramick@xxxxxxxxxxx>
- To: <fairlie_r@xxxxxxxxx>, <sac@xxxxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 May 2006 11:26:12 -0700
Thanks, Fairlie.
The procedure in the link seems to work only for system-wide determination
or am I missing something?
oradebug setmypid
Statement processed.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000000 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000
SQL> alter system set use_stored_outlines = true;
System altered.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000001 45440007 4C554146 00000054
00000000 00000000 00000000 00000000 00000000
SQL> alter system set use_stored_outlines = false;
System altered.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000002 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000
SQL> alter session set use_stored_outlines = true;
Session altered.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000002 00000000 00000000 00000000
00000000 00000000 00000000 00000000 00000000
SQL> alter system set use_stored_outlines = true;
System altered.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000003 45440007 4C554146 00000054
00000000 00000000 00000000 00000000 00000000
SQL> alter session set use_stored_outlines = false;
Session altered.
SQL> oradebug dumpvar sga sgauso
qolprm sgauso_ [2000F514, 2000F538) = 00000003 45440007 4C554146 00000054
00000000 00000000 00000000 00000000 00000000
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of fairlie rego
Sent: Thursday, May 25, 2006 6:01 AM
To: sac@xxxxxxxxxxxxx; oracle-l
Subject: Re: Why is USE_STORED_OUTLINES not an initialization parameter?
Hi,
I know that this was logged as an enhancement back in version 8.1.7 but as
with many others there has been no progress .......
Also IIRC the only way to find out if a session is using a stored outline
and its category is using oradebug as illustrated in
https://www.metalink.oracle.com/metalink/plsql/f?p=200:27:118226180006509377
6::::p27_id,p27_show_header,p27_show_help:613682.992,1,1
HTH,
Fairlie
"Schultz, Charles" <sac@xxxxxxxxxxxxx> wrote:
We have begun exploring the use of outlines, and one of the things I
stumbled upon was that you have set "use_stored_outlines". As we discuss
this feature and talk about ramifications, we have discovered that there is
a wee bit of overhead in a shop with many databases. Each time we clone or
bounce a database, we would have to turn outlines back on. Of course, there
is the option of creating a database trigger that does this automagically,
but it does make me wonder why it is not an init parameter. I assume there
is a good reason that Oracle decided on this. Anyone happen to know the
details?
PS - I do realize that this parameter can also have other values besides
TRUE and FALSE. I am hoping to focus this question on the boolean values,
however. Unless the non-boolean values are part of the decision making
process.
charles schultz
oracle dba
aits - adsd
university of illinois
Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
www.optus.com.au
________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail Beta.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
