RE: Large Pool zero

  • To: <ramick@xxxxxxxxxxx>, <mcdonald.connor@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 May 2006 09:42:06 -0700

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
 
** The opinions and facts contained in this message are entirely mine and do 
not reflect those of my employer or customers **

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of ramick
Sent: Thursday, May 25, 2006 8:59 AM
To: mcdonald.connor@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Large Pool zero

Don't forget that rman uses large pool also.

________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Connor McDonald
Sent: Thursday, May 25, 2006 7:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Large Pool zero


On 5/25/06, Peter McLarty <Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx
Web:
www.TechnologyOneCorp.com


--
//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@xxxxxxxxx
web:   http://www.oracledba.co.uk 

"Semper in excremento, sole profundum qui variat" 

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


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


Other related posts: