Home » RDBMS Server » Server Utilities » Troubleshoot for import data
Troubleshoot for import data [message #429680] Thu, 05 November 2009 03:33 Go to next message
chuotlun4mat
Messages: 1
Registered: November 2009
Location: Viet Nam
Junior Member
Hi ,all
Please reply me How to tuning oracle PUMP data

+ My database size is 1,2 TB
+ 20 users which have default user,temp tablespace
+ undo_retention : 43200
+ online redo log : 104 MB which in 3 log group

When I delete one user to import new data for this user
My size .dmp file : 15 GB
My database is very slowly to do this (about 4 days or more )
How can i increase speed to import data.

My information server :
CPU: xeon 2.2GHZ
RAM: 4GB
Hard disk: 2 TB(intel MegaSR SCSI Disk)





Re: Troubleshoot for import data [message #429830 is a reply to message #429680] Thu, 05 November 2009 22:40 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
chuotlun4mat wrote on Thu, 05 November 2009 03:33
Hi ,all
Please reply me How to tuning oracle PUMP data


From which version ?

Sriram
Previous Topic: Data Pump API error help
Next Topic: dataloading with sql*loader without archie
Goto Forum:
  


Current Time: Fri Dec 09 08:11:41 CST 2016

Total time taken to generate the page: 0.23543 seconds