| Importing very Slow??? HELP NEEDED URGENTLY?? [message #70625] |
Mon, 08 July 2002 21:06  |
marjo
Messages: 9
Registered: January 2002
|
Junior Member |
|
|
Hello Friends:
I am importing a dump file, while do so I come across one table in my database which has 85000 records in it. At this stage it takes hell lot of time for importing, and later on gets hanged. Somebody told me that I can solve this problem by increasing the size of rollback segment. Is is true? if yes explain me step by step how to increase it. If no then give me the solution.
Bye.
Marjo.
|
|
|
|
|
|
| Re: Importing very Slow??? HELP NEEDED URGENTLY?? [message #70832 is a reply to message #70625] |
Mon, 29 July 2002 03:17  |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
There are many methods to increase the performance of the import/ export
1) set the BUFFER to a high values i.e. buffer=1000000
2) Startup the database in Restrict Session if you can
3) increase the db_block_buffer size
4) increase the log_buffer_size
5) use DIRECT=Y if you are allow to do it
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
