Home » RDBMS Server » Server Utilities » Import export (oracle 9.2.0.1.0 , Linux 8/9/server 4 , windows 2000 professional)
Import export [message #298106] Tue, 05 February 2008 00:49 Go to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Hi experts,
I want to know about export and import's BUFFER switch. I know that Buffer size set to fetch rows. if Buffer=0 then one row will be fetched at at one time. so tell me if I set buffer size 512,1024,2048,4096 etc then , How many rows will be fetched at one time. If Buffer parameter is not to be seted then how many rows will be fetched at one time.



Thanks
Vivek
Re: Import export [message #298108 is a reply to message #298106] Tue, 05 February 2008 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
How many rows will be fetched at one time.

trunc(buffer size/row size)

Quote:
If Buffer parameter is not to be seted then how many rows will be fetched at one time.

What is the default value stated in your documentation?

Regards
Michel
Re: Import export [message #298116 is a reply to message #298108] Tue, 05 February 2008 01:24 Go to previous messageGo to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Does it affect memory? If I have 8 GB RAM then how much should me to set the buffer size .
Re: Import export [message #298124 is a reply to message #298116] Tue, 05 February 2008 01:30 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Of course buffer uses memory.
What you can set depends on your free memory.
I use 100000000.

Regards
Michel
Previous Topic: SQLPlus loading data
Next Topic: Loading binary data
Goto Forum:
  


Current Time: Tue Dec 24 22:38:20 CST 2024