I would think that the latest version of Oracle still has the hidden parameter _make_sql_run_faster which you set to "TRUE" which, with all these other things, should also help. Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Wolfgang Breitling Sent: Thursday, February 17, 2005 8:17 PM To: mgogala@xxxxxxxxxxxxxxxxxxxx Cc: juancarlosreyesp@xxxxxxxxx; oracle-l Subject: Re: 66,000.00 times slower, please your opinion At 03:42 PM 2/17/2005, Mladen Gogala wrote: >5) set spin_count=2048 Mladen, Mladen, you are slipping. Everyone knows that you need to set the spin_count = log(rotation speed of your disks). Double it for single-cpu systems ;-) Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l