Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Large Pool zero

RE: Large Pool zero

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 25 May 2006 09:42:06 -0700
Message-ID: <BEE6A332AA61424EAE305CF89D6F75C84BB459@USSCCEVS101.corp.hds.com>


Ramick/Peter,

The requirement of Large Pool for RMAN is a myth (#4 in ML Note 134214.1). Apparently, configuration of the LARGE_POOL_SIZE in a RMAN backed up database is required *ONLY* if using DBWR_IO_SLAVES or BACKUP_TAPE_IO_SLAVES. If these parameters are not used, the Input and Output buffers for the RMAN process is used out of the session's PGA. (The Large Pool of course should be configured if MTS is in use, but it does not necessarily have to be configured for RMAN to be used).  

For other RMAN myths, see ML Note 134214.1. Incidentally, Myth # 2 has to be modified to add a caveat for 'block change tracking' enabled Oracle Database 10g databases - See ML Note 262853.1.  

Regards,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Fear connects you to the Negative, but Faith connects you to the Positive! I Jn 4:18  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ramick Sent: Thursday, May 25, 2006 8:59 AM
To: mcdonald.connor_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Large Pool zero

Don't forget that rman uses large pool also.



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connor McDonald
Sent: Thursday, May 25, 2006 7:27 AM
To: oracle-l_at_freelists.org
Subject: Re: Large Pool zero

On 5/25/06, Peter McLarty <Peter_McLarty_at_technologyonecorp.com> wrote: Hi

Hi
I have come across some sites recently where the large pool has been set to 0, these are 9i sites

Anyone hazard to guess as to why, I haven't found anything substantial on google or metalink

Cheers

Peter McLarty
Technical Consultant
Service Delivery

Address:
67 High Street, Toowong QLD 4066
Phone:
+61 7 3377 7300
Fax:
07 3377 7301
Mobile:
+61 4 1062 0391
Email:
Peter_McLarty_at_TechnologyOneCorp.com
Web:
www.TechnologyOneCorp.com

--

http://www.freelists.org/webpage/oracle-l

large pool isn't used by of lot of things, so its not a mandatory pool to have floating around...If you're worried, bump it up to 8m and check v$sgastat from time to time to see if its being used.

--

Connor McDonald



email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 25 2006 - 11:42:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US