-
HI ,
I need to do an Import, the dump is in 5 seperate files each of 1 GB size.
Can any one suggest me how to do it in very less time?
Thanks
esreddy
-
Hello;
Set the BUFFER-Val very high ( Increasing the INSERT-rowset-size );
and it would be best if the dumps has been created with DIRECT=Y
Is your DB in ARchive-log-Mode?
Probably switching the DB to NONARCHIVELOG-MODE
Then importing
Then ARCHIVELOG-MODE
Then Full-backup of DB
would be faster too
Your IO between Online-Redo and Datafiles should be seperated
Your Redo-files should be large due to less checkpointes >= 64M
The Dumpfiles may not be in the Storage of the Database at all; Best : own disk and controller;
COMMIT=N could overflow the ROLLBACK-Segments
Orca
[Edited by Orca777 on 06-12-2002 at 02:31 AM]
-
i have given BUFFER=100000 COMMIT=N
still it is taking so much time
-
Originally posted by esreddy
i have given BUFFER=100000 COMMIT=N
still it is taking so much time
I would set the buffer at around 4,000,000 and commit =Y
This way after 4 million bytes (3MB's roughly) you will commit your insert. With commit=N Oracle will only commit after the entire table is imported, this can be a problem with large tables.
MH
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|