rman Ora-4031 - how to flush large pool?
From: Douglas Cowles <dcowles_at_us.ibm.com>
Date: Mon, 14 Jul 2008 20:36:22 -0400
Message-ID: <OFF71087BA.C22E300B-ON85257487.0003148A-85257487.000354AD@us.ibm.com>
Date: Mon, 14 Jul 2008 20:36:22 -0400
Message-ID: <OFF71087BA.C22E300B-ON85257487.0003148A-85257487.000354AD@us.ibm.com>
We have a system that is throwing ORA-4031's in rman archive log backups after the system has been up a few days. To my understanding, RMAN tries to use the large pool for it's activities. When we alter system flush shared pool - the errors do not stop - the database has to be bounced or the large_pool has to be increased 3M or so. Does alter system flush shared_pool flush the large pool? If it does, then why would that not defragment the pool? If it does not, is there a way to do it? In general, will flushing the shared_pool defragment it - large pool or otherwise?
Thanks,
Doug C.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 14 2008 - 19:36:22 CDT