-
imp Buffer parameter
Hi All ,
Can anyone suggest how to decide on the buffer parameter while importing huge database (exp dump 25GB )
i mean on what factors does buffer parameter depend on UNIX and Windows NT ( RAM , SGA , etc ... ) what percent of this can i use .
appreciate your help .
-
I would make your buffer the same size as your rollback segment.
Jeff Hunter
-
sum of all the rollback segments or system rollback segment
i am using 8.1.7
or do i create a very big single rollback segment of 5GB and then keep the buffer = 5GB while importing
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
|