Re: write performance - broad generalization
Date: Fri, 3 Apr 2009 11:42:53 -0700
Message-ID: <bf46380904031142r4cf53707p9676c9c0f9c2e81c_at_mail.gmail.com>
On Fri, Apr 3, 2009 at 5:18 AM, Michael McMullen <ganstadba_at_hotmail.com>wrote:
> Whenever I get a new server or even compare write performance between
> servers, I just create a 10GB tablespace (not temp). I time it and I think
> it gives me a kind of max write performance (for oracle), no other work is
> going on, just the one tablespace being created. Real quick & dirty test.
> Yesterday I got a brand new dev box and it took ~7 minutes for a 5GB
> datafile. A 10GB datafile on another box that I recently set up < 1 minute.
> Top of my head I think my new dev box is a dog. I don’t need to go into
> specifics on the file system they gave me or the underlying storage. Just
> wondering if I’m way off base. I’ll have to go through my docs. I think I’ve
> done test with multiple sqlloader sessions doing direct loading to see if my
> throughput matches my simple test but I’m not sure.
>
> At this point you might try making the file using something other than
oracle
and see how log it takes.
Knowing the platform might be useful.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 03 2009 - 13:42:53 CDT