stored outline for a 3rd party application
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Thu, 10 Feb 2005 08:50:52 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
