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_at_comcast.net; 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_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 load?

--

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

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 18 2008 - 05:15:25 CST