|
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 |
