Home » RDBMS Server » Server Utilities » Export dump of large table (oracle10.2.0.4, 9.2.0.8 , Solaris 10)
Export dump of large table [message #450747] Fri, 09 April 2010 01:35 Go to next message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Hi Experts,
We have two databases running on 10.2.0.4 and 9.2.0.8.
Both are having the same unpartitioned table of size 80G.
I am exporting the table on 10g by using parallel=8 and dumpfile with %U option. That took around 4 hours to export the table.

And on 9.2.0.8, i am exporting using below parameters, taking around 5 hours.
buffer=2000000
recordlength=64000

Can you suggest me some options i can try to speed up the export in both versions.

Thanks in advance for your suggestions.

Regards
Lalit
Re: Export dump of large table [message #450751 is a reply to message #450747] Fri, 09 April 2010 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 67652
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Increase buffer, 2M is small.

Regards
Michel
Re: Export dump of large table [message #450757 is a reply to message #450747] Fri, 09 April 2010 02:05 Go to previous message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Thanks Michel.
I will test it out with some high value of Buffer.

Regards
Lalit
Previous Topic: sql*loader
Next Topic: How to load if the data is in the control file as well as in the datafile (2 threads merged by bb)
Goto Forum:
  


Current Time: Sun Jan 24 16:36:26 CST 2021