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