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>

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?

Doug C.

Received on Mon Jul 14 2008 - 19:36:22 CDT

Original text of this message