Re: Re: predicting performance of sql loading a 400 GB file
- From: "anysql" <anysql@xxxxxxxxx>
- To: "nigel_cl_thomas@xxxxxxxxx" <nigel_cl_thomas@xxxxxxxxx>, "ryan_gaffuri@xxxxxxxxxxx" <ryan_gaffuri@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Feb 2008 19:15:25 +0800
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?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re: Re: predicting performance of sql loading a 400 GB file
