tuning question...

From: <gdas_at_my-deja.com>
Date: Fri, 25 Aug 2000 20:36:34 GMT
Message-ID: <8o6lcg$h1u$1@nnrp1.deja.com>

I have query down to a level where the overall optimizer cost is "2"...However the query still takes an awfully long time to run... (almost 5 minutes). When I look at the statistics for the query,

The following items caught my eye:

5307293 consistent gets
158609 physical reads

What exactly is a "consistent get?" Are there any init.ora parameters that I can fiddle with to try to get these numbers down?

Thanks in advance.
Gavin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 15:36:34 CDT