| Avi |
Posted: May 01, 2007 01:23:33 AM |
Total Post: 7
Joined: Apr, 2007
|
i recently tried to tune a database which had around 3 lack records..
initial importing was really fast..and first 25% completed in 5 minutes sut the rest 75 % took around 1 hour..
can u tell me the reason wht the database has slow down..
i hv designed database appropriately with appropriate tablespace, undosegments, and logfiles.. |
|
|
 kareem |
| Posted: Jun 04, 2007 01:09:53 AM |  |
|
Total Post: 5
Joined: May, 2007
|
Try to allocate different temproray tablespace for the schema in which you are importing the data.And also it is depent on you IO and memory performance.
|
|
|
|
|
| chitta |
| Posted: Aug 08, 2007 09:51:29 AM | |
|
Total Post: 4
Joined: Aug, 2007
|
if you import indexes too,then it may cause the problem.
import tables alone and recreate the indexes seprately using indexes=n and indexfile='location'
most of the time indexes are causing these kind of problems.
|
|
|
|
|
| siva |
| Posted: Aug 09, 2008 05:43:12 AM | |
|
Total Post: 13
Joined: Aug, 2008
|
using import performance parameters like,
commit=y
buffer=size(10m)
indexfile='location'
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
