Re: Tuning help

From: Mladen Gogala <mgogala.SPAM-ME_at_not-at-verizon.net>
Date: Wed, 2 May 2007 22:39:13 +0200 (CEST)
Message-ID: <pan.2007.05.02.20.34.34@not-at-verizon.net>

On Wed, 02 May 2007 21:07:32 +0200, astalavista wrote:

> Can you help me to tune this query
> thanks in advance ...

Gladly. What is the Oracle version, how long does it take, what is the response time you strive? How many records do the tables involved have? Are there histograms for the indexes? Can you post the output of the 10046 trace so that we can see what are you waiting for?

-- 
http://www.mladen-gogala.com

Received on Wed May 02 2007 - 15:39:13 CDT