Home » RDBMS Server » Server Utilities » Time efforts for Export/Import
Time efforts for Export/Import [message #73264] Thu, 11 March 2004 20:28 Go to next message
Pandari Suresh Kumar
Messages: 5
Registered: October 2001
Junior Member
hi all

i'd like to know how much time will be taken to export 1gb data from a oracle server (sun solaris) and also same like importing (linux) tooo...any calculation to make this effort, pls let me know

thanks in advance

regards

suresh
Re: Time efforts for Export/Import [message #73266 is a reply to message #73264] Thu, 11 March 2004 22:31 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

There is no way anybody can tell you how long it will take to do an export/import. There is just too many unknowns - Server Utilization, CPU Speed, Disk Speed, Kernel Parameters, Type of Filesystem used, Disk Fragmentation, Oracle Parameters, Data Structures, Database Fragmentation, etc.

Best would be to test it to get the actual timing for your system, and base your calculations on that.

Best regards.

Frank
Previous Topic: Insert into multiple tables
Next Topic: clarification on sql loader
Goto Forum:
  


Current Time: Tue Nov 12 13:50:28 CST 2024