outlines don;t work

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Wed, 25 Aug 2004 16:08:58 +0300
Message-ID: <EC77AB8681A2B44B895956EE2A2D10A50C291B@XCHVSRV01.evergy.local>

   

Dear All,  

Have the following problem:  

Config info: Sun Solaris 5.8 , oracle 8.1.7.4 32 bit  

I need to create outlines for a sql statement inside a PL/SQL due to the reason that one of the tables used by this query was recently partitioned and the performance degraded.

So what I do is:

Have created a replica non partition table, set stored outlines , run pl/sql and got the before explain plam. I do the same with the partition table. I then exchange the hints and hintcount between the two and try to use the outline ( this procedure is detailed on a document compiled by Jonathan Lewis http://www.dbazine.com/jlewis4.html) .

Although I alter the session to use the correct category the outline is not used.

Has anybody tried this before? Any hints!  

Kind Regards,  

Hatzistavrou Yannis  

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Aug 25 2004 - 08:04:42 CDT