RMAN does not ALWAYS use large_pool. See: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7275792247455#38772533999101 for more details.... -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ramick Sent: Thursday, May 25, 2006 11:59 AM To: mcdonald.connor@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: [SPAM] RE: Large Pool zero Importance: Low 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