(Import) equation for buffer value & server memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: (Import) equation for buffer value & server memory

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    (Import) equation for buffer value & server memory

    In import there is parameter buffer

    The value u can give to several MB's

    but it also depends upon the OS MEMORY ALSO,

    I want to know the equation

    For how much memory availabe in OS how much buffer value can be given?

    HOW TO FIND OUT THAT

    now example - suppose the database server is having 1 Gb memory and i want to do import, what buffer value i can give to maximum

    Gajanan

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Docs are a good thing

    BUFFER
    Default: operating system-dependent

    The integer specified for BUFFER is the size, in bytes, of the buffer through which data rows are transferred.

    BUFFER determines the number of rows in the array inserted by Import. The following formula gives an approximation of the buffer size that inserts a given array of rows:

    buffer_size = rows_in_array * maximum_row_size


    For tables containing LONG, LOB, BFILE, REF, ROWID, UROWID, or DATE columns, rows are inserted individually. The size of the buffer must be large enough to contain the entire row, except for LOB and LONG columns. If the buffer cannot hold the longest row in a table, Import attempts to allocate a larger buffer

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    My KISS standard is...

    BUFFER=12000000
    COMMIT=y

    Never fails.
    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
  •  


Click Here to Expand Forum to Full Width