| buffer & direct urgent [message #73859] |
Mon, 26 July 2004 22:10  |
shyam
Messages: 25
Registered: January 2001
|
Junior Member |
|
|
i am doing full db Export.I had 30 gb database .i have ram 1gb how much i have to set max value for buffer.if i give this value 100,00,000 how much ram it will take.If there is any perfomance gain if i choose direct path way like direct=y any problems for improting the data to different db.
any hlp will be appreciated
shyam
|
|
|
|
| Re: buffer & direct urgent [message #73881 is a reply to message #73859] |
Wed, 28 July 2004 05:00  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Yes Direct=Y will have gain in Performance.
If the data is correct and there are no errors in it then there will not be any problem to import it into other DB.
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
