OraFAQ Forum: Server Utilities » What does the Buffer imply in the Import and Export ?

Home » RDBMS Server » Server Utilities » What does the Buffer imply in the Import and Export ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What does the Buffer imply in the Import and Export ? [message #192390]

Tue, 12 September 2006 02:44

amkotz
Messages: 72
Registered: May 2005
Location: Bangalore

Member

Hi,

I am trying to import a dump file of total around 5 Gb.
In the import statement i have given buffer = 100000000

But it is very slow. It is importing the objects , but it is taking more than 15 hours to import. Normally it takes around 4 hours.

Comapring with the previous imports i have only increased the Buffer size. What may be the problem ?

Does the space availability on the local drives hamper the operation. ?

Thanks ,
Amkotz

Report message to a moderator

Re: What does the Buffer imply in the Import and Export ? [message #192406 is a reply to message #192390]

Tue, 12 September 2006 03:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> buffer = 100000000
This is way too high and will slow down your export.
reduce several of those trailing zeroes.
quoting documentation

Default: operating system-dependent. See your Oracle operating system-specific documentation to determine the default value for this parameter.

Specifies the size, in bytes, of the buffer used to fetch rows. As a result, this parameter determines the maximum number of rows in an array fetched by Export. Use the following formula to calculate the buffer size:

buffer_size = rows_in_array * maximum_row_size

If you specify zero, the Export utility fetches only one row at a time.

Report message to a moderator

Re: What does the Buffer imply in the Import and Export ? [message #192422 is a reply to message #192406]

Tue, 12 September 2006 05:07

amkotz
Messages: 72
Registered: May 2005
Location: Bangalore

Member

Hi,

Where do i found the parameters:

rows_in_array
maximum_row_size

Thanks,
Amkotz

Report message to a moderator

Re: What does the Buffer imply in the Import and Export ? [message #192447 is a reply to message #192422]

Tue, 12 September 2006 07:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

In documentation?
or
google?
just reduce the buffer value. you will see the difference.
Read the utilities manual.

Report message to a moderator

Previous Topic:	loading from other applications
Next Topic:	Need help in importing data from csv

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:17:04 CST 2024