-
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.
-
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