Home » RDBMS Server » Server Utilities » Export Buffer size (Oracle8 / Solaris10)
Export Buffer size [message #324671] Tue, 03 June 2008 11:08 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

i am about export a table and i wanna know if this size is good for do it
SQL> desc USR_SIST_NEGOCIO.HIS_PAD_VOU_DETALLE
 Name                   Type
 ----------------------------
 HVD_NUMERO_VOUCHER    NUMBER(10)
 HVD_SEG1              VARCHAR2(8)
 HVD_SEG2              VARCHAR2(2)
 HVD_SEG3              VARCHAR2(5)
 HVD_SEG4              VARCHAR2(4)
 HVD_SEG5              VARCHAR2(5)
 HVD_SEG6              VARCHAR2(8)
 HVD_SEG7              VARCHAR2(2)
 HVD_SEG8              VARCHAR2(2)
 HVD_MONTO_DEBE        NUMBER(20,8)
 HVD_MONTO_HABER       NUMBER(20,8)
 HVD_PERIODO           DATE


It has aprox 13kk of rows
can the buffer size be 1.6G?

i followed this formula to calculate the buffer size

http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1005586
Re: Export Buffer size [message #324672 is a reply to message #324671] Tue, 03 June 2008 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have the memory enough.

Regards
Michel
Re: Export Buffer size [message #324674 is a reply to message #324672] Tue, 03 June 2008 11:22 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Tue, 03 June 2008 11:16
If you have the memory enough.

Regards
Michel


Michael, i think i have this memory
but if i dont have it... what do you think i must to do? maybe is better to dont put the buffer parameter in the parfile?
or you have any suggestion?
thank you a lot
Re: Export Buffer size [message #324676 is a reply to message #324674] Tue, 03 June 2008 12:01 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use the larger buffer your memory allows you.
This is the only rule.

Regards
Michel
Previous Topic: Sql*Loader Error - While using direct path load
Next Topic: export time
Goto Forum:
  


Current Time: Sat Dec 03 12:09:57 CST 2016

Total time taken to generate the page: 0.08529 seconds