RE: 66,000.00 times slower, please your opinion

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <breitliw@xxxxxxxxxxxxx>, <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • Date: Fri, 18 Feb 2005 09:22:44 -0500

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

Other related posts: