RE: 66,000.00 times slower, please your opinion

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 18 Feb 2005 09:22:44 -0500
Message-ID: <001101c515c5$4fdcd3e0$8459000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling Sent: Thursday, February 17, 2005 8:17 PM To: mgogala_at_allegientsystems.com
Cc: juancarlosreyesp_at_gmail.com; 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

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

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

Received on Fri Feb 18 2005 - 09:25:59 CST