U can't remeber why coalesce didn't work for us... I'll try to recall it. On Mon, 24 Jan 2005 23:04:59 -0500, Michael Kline <mkline1@xxxxxxxxxxx> wrote: > And where is the "alter shared_pool coalesce;" ???? > > :-) > > Michael Kline > Principal Consultant > Business to Business Solutions > 13308 Thornridge Ct > Midlothian, VA 23112 > O: 804.744.1545 > Fax: 804.763.0114 -- Best regards, Alex Gorbachev -- //www.freelists.org/webpage/oracle-l