Re: Improving fetch times

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 06 Aug 2007 12:59:55 +0300
Message-ID: <46B6F11B.6090700@inter.net.il>

The cause was statistics-level = 'all'.
After I changed it to 'typical' the system works fine.

Adar Yechiel
Rechovot, Israel

Yechiel Adar wrote:
> I have a problem with a query that takes a long time to fetch.
> Each execution fetch about 6-7,000 rows.
> How can I improve the fetch phase?
> I will also open a TAR but I decided to ask also for your help.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 06 2007 - 04:59:55 CDT