Re: Re: predicting performance of sql loading a 400 GB file

Hi:

I think you should split it into multiple smaller files, and then do the load, 
easy for manage and resume from failure.


Thanks.

-- Fangxin Lou, Oracle DBA, from China

Good tools make work easy and improve life quality
-- http://www.dbatools.net

Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en
-- http://www.anysql.net   (Chinese)



From： Nigel Thomas 
Sent： 2008-02-18  18:49:28 
To： ryan_gaffuri@xxxxxxxxxxx; oracle-l 
CC： 
Subject： Re: predicting performance of sql loading a 400 GB file 
Ryan

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@xxxxxxxxxxx"  <ryan_gaffuri@xxxxxxxxxxx >
To: oracle-l@xxxxxxxxxxxxx
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 load? 

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

Other related posts: