RE: exp and LARGE_POOL_SIZE (mail HTML format)

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 17 Aug 2004 01:12:14 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09EFEB13@bosmail00.bos.il.pqe>

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_at_freelists.org on behalf of Sinardy Xing
Sent:	Mon 8/16/2004 11:43 PM
To:	oracle-l_at_freelists.org
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_at_freelists.org
[ mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sinardy Xing Sent: 17 August 2004 11:40
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Binary/unsupported file stripped by Ecartis --
Type: application/ms-tnef
File: winmail.dat

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Aug 17 2004 - 00:07:56 CDT