Re: predicting performance of sql loading a 400 GB file
Date: Mon, 18 Feb 2008 12:38:49 +0000
I concur, in fact a relatively common question on various forums goes like this
"I have a batch process that loads X million records into a table. At first it goes really fast with the first Y thousand records loading in seconds. As it progresses the load goes slower and slower, what's happening?"
On Feb 18, 2008 10:48 AM, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> wrote:
> I simply don't know what the scaling effects might be - therefore I would
> have to assume they might not be linear. That would suggest that you should
> try several values and plot them. 0.25% seems a very small sample to me -
> 10% might be more like it - so why not try at values like: 10, 20, 40, 80Gb
> and see what happens?
> Of course that's not to say there's no chance of some scaling effect
> coming into play at 100, 200 or 399Gb that you weren't expecting.
> Regards Nigel
> ----- Original Message ----
> From: "ryan_gaffuri_at_comcast.net" <ryan_gaffuri_at_comcast.net>
> To: oracle-l_at_freelists.org
> Sent: Monday, February 18, 2008 2:05:27 AM
> Subject: predicting performance of sql loading a 400 GB file
> I don't have a 400 GB file and I don't have storage space for it to leave
> a file on disk to run the test. If I do some test loads of a 1 GB data file,
> does anyone know if this will scale up linearly? what is the minimum size
> file I should use in order to get some idea of predicting performance of the
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 18 2008 - 06:38:49 CST