Re: write performance - broad generalization
Date: Fri, 3 Apr 2009 11:42:53 -0700
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
and see how log it takes.
Knowing the platform might be useful.
Certifiable Oracle DBA and Part Time Perl Evangelist