Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What tuning can be done on disk writes?

Re: What tuning can be done on disk writes?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Oct 2005 11:16:26 -0700
Message-ID: <1129832180.624265@yasure>


jonathan.gauthier_at_gmail.com wrote:
> I created a simple script that does 1000000 inserts into a table. I can
> run this in 3 minutes on my cheap home computer but it takes 8 minutes
> on our new extra expensive solaris server on SAN disks.
>
> The SAN is not all that busy and statspack tells me I/O waits account
> for 99% of the job time. What can be configured in solaris to fix this?

 From my experience Sun Microsystems has little relationship, today, with the company we all knew and loved a decade ago. Back then they made the chips, the operating system, etc. Now they are basically a brand name on whatever they can sell for a competitive price ... likely bolted together in whatever country was willing to do it for the lowest cost. Their SAN's are boat anchors.

That said ... what is the storage strategy? Copper for fibre?
Swithes? Are they zoned?
How many LUNs?
etc.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 20 2005 - 13:16:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US