| Troubleshoot for import data [message #429680] |
Thu, 05 November 2009 03:33  |
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)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
