Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> stored outline for a 3rd party application

stored outline for a 3rd party application

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 10 Feb 2005 08:50:52 -0500
Message-Id: <s20b2082.026@gcrta.org>


We have a SQL statement that is running poorly from a 3rd application and I was hoping to use stored outlines so that I could add a database hint. Looking into this I find that the stored outline SQL must match the actual SQL exactly (which uses bind variables). I can grab the sql from v$sql but how can I get it into the outline so it will have the same hash value?      

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 10 2005 - 08:53:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US