sql with bind variable in stored procedure doesnt use stored outlines

All, I am unable to make stored outlines work for sql statements with bind variable in stored procedures. Please see following sample code and tell me what am I doing wrong. Thanks in Advance create table emp (num number,sal number);insert into emp values(1,1);create or replace procedure

Re: sql with bind variable in stored procedure doesnt use stored outlines

;alter session set STAR_TRANSFORMATION_ENABLED=true;alter session set use_stored_outlines=true;exec t;select used from dba_outlines;select sal from emp;select used from dba_outlines; - Original Message - From: orafaq To: [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:08

create_stored_outlines does not work -urgent

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

Re: Increase size of data files and rollback segments

-- Author: orafaq INET: [EMAIL PROTECTED] 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

Re: limiting temp space per user

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

AQ query from dequeuw procedure not using index -URGENT

All, We are using a third party application (Retek Warehouse management) which uses AQ as communication mechanism between processes. The problem we are facing is that the AQ query behind Dequeue is doing a full tablescan on queue table which is causing about 5Billion logical reads/day and

Re: AQ query from dequeuw procedure not using index -URGENT

Title: RE: AQ query from dequeuw procedure not using index -URGENT This database is running RULE so analyzing wont help. Outlines is a good idea. Any known issues with outlines in 8173? Thanks Shaleen - Original Message - From: Jamadagni, Rajendra To: Multiple recipients

Re: AQ query from dequeuw procedure not using index -URGENT

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: LGWR using lots of CPU time, low CPU usage

, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City

Re: OT- mailx option

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: instance shutdown problem ? (please help)

://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] 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

Re: instance shutdown problem ? (please help)

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Problem doing RMAN backup of Clone?

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

my messages are not getting to list. trying to testeom