I have been trying
to get stored outlines to work. It seems simple enough, but it is working
the exact opposite as I think it should. Anyone else use these?
I am on 8.1.7.4 on HP-UX 11.00
In a nutshell, I
verify my query is using the correct explain plan. I grant 'create any
outline' to the users.
Then, I
do:
alter system set
use_stored_outlines = true
ALTER SESSION SET
CREATE_STORED_OUTLINES=true;
select * from edi_monitor_vw;
ALTER SESSION
SET CREATE_STORED_OUTLINES=false;
I can see the
outline in DBA_OUTLINES and also in outln.ol$
If I open another
session and run the query, it is NOT using the correct explain
plan.
If I 'alter system
set use_stored_outlines = false;' then the query uses the correct
plan.
I also noticed that
outline_category in v$sql is NULL. Does this mean that they outline
is not being used? I assume not.
Thanks
all,
John
John
Fedock
"K" Line America, Inc.
www.kline.com
* john.fedock@us.kline.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fedock, John (KAM.RHQ)
INET: John.Fedock_at_us.kline.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 29 2004 - 10:29:26 CST