The responsible

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 7 Feb 2006 12:46:54 -0400
Message-ID: <cd4305c10602070846m5f4d80c9v71ec7ef913bfbf52@mail.gmail.com>

HI I want to share this info, not asking.

Some years ago I changed the optimizer parameters, and this solved a query, from minutes to seconds
OPTIMIZER_INDEX_COST_ADJ = 10
OPTIMIZER_INDEX_CACHING = 90
Now the situation reversed, and I had to comment them To move a process from 4 minutes to 7 seconds.

using optimizer parameters 10,90
trace file 870 M
time 4 minutes (without trace)
recursive 465.43 s
non recursive 233.21 s

commenting optimizer parameters and leaving with their defaults Trace file 6 M
time 7 seconds
recursive 5.87 s
non recursive 1.79 s

--

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 07 2006 - 10:46:54 CST