rman Ora-4031 - how to flush large pool?
- From: Douglas Cowles <dcowles@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 14 Jul 2008 20:36:22 -0400
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.
Other related posts:
