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