Oracle-L: create_stored_outlines does not work -urgent

From: orafaq <shgarg_orafaq_at_hotmail.com>
Date: Tue, 10 Dec 2002 15:28:52 -0800
Message-ID: <F001.005170CF.20021210152852@fatcity.com>

Hi,

We are having a full tablescan issue with query used by DBMS_AQ.deque procedure and as per John's recommendation I am playing with outlines to fix this issue. Since this is an internal query I do not have the exact text of the query . So I was trying to create the outline and when I execute following piece code no outlines are created. Can you help in this? alter system set create_stored_outlines=true; declare
typ number(10);
msglen number(10);
msg varchar2(4000);
begin
rdmtcpuser.gentcp.Dequeue('KEWILL_SHIP0_PR_OUT',1,typ,msglen,msg ); end;
/
alter system set create_stored_outlines=false; This should logically create outlines for all the sqls executed by dequeue.

I turn the trace on this session which shows me the sqls being executed but no outline is created. Although I do have create outline permissions and if I execute sql statements then outlines are created for those. Only for procedure outline is not created.

Thanks
Shaleen

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: orafaq
INET: shgarg_orafaq_at_hotmail.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 Tue Dec 10 2002 - 17:28:52 CST