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

Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP: Oracle running really slow.

Re: HELP: Oracle running really slow.

From: Anton Dischner <dischner_at_klch.med.uni-muenchen.de>
Date: Wed, 15 Nov 2000 12:24:55 +0100
Message-ID: <151120001224557038%dischner@klch.med.uni-muenchen.de>

Hi Dan,

did you try optimizer hints?
I have very good results with:

alter session set optimizer_goal = rule;  ... first_rows

Or use:

select /*+ rule */ Count(*)

   From jwl_rep, jwl_alignment
   Where jwl_rep.rep_id = jwl_alignment.rep_id;

select /*+ first_rows */ Count(*)

   From jwl_rep, jwl_alignment
   Where jwl_rep.rep_id = jwl_alignment.rep_id;

See: file:/816_DOCS/DOC/server.816/a76992/hints.htm in your generic help CD.

Good luck,

Toni

-- 
ZXR750H, 55 Mm. 
Q: How did the medical community come up with the term "PMS"?
A: "Mad Cow Disease" was already taken.
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
Received on Wed Nov 15 2000 - 05:24:55 CST

Original text of this message

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