Export will not use memory from the large pool. It will consume the server process's PGA memory. To prove it, you could run exp and then use an O/S tool (such as pmap on Solaris) to examine how much memory of what kind has been allocated. If you define a 100MB buffer, I'd expect to see 100MB in private process memory allocated to the server process. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Sinardy Xing Sent: Mon 8/16/2004 11:43 PM To: oracle-l@xxxxxxxxxxxxx Cc: Subject: exp and LARGE_POOL_SIZE (mail HTML format) Hi all, If I have exp and imp with buffer=100MB Will buffering make use LARGE POOL? Do you think I have to set my LARGE_POOL_SIZE to =128 MB or this LARGE_POOL_SIZE design only for MTS and RMAN operations? Thanks Sinardy -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [ mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sinardy Xing Sent: 17 August 2004 11:40 To: oracle-l@xxxxxxxxxxxxx Subject: exp and LARGE_POOL_SIZE Hi all, If I have exp and imp with buffer=3D100MB will buffering make use LARGE POOL? should I set my LARGE_POOL_SIZE to = 128 MB or this LARGE_POOL_SIZE design only for MTS and RMAN operations? Thanks Sinardy ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: application/ms-tnef -- File: winmail.dat ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------