Re: rman Ora-4031 - how to flush large pool?
Date: Tue, 15 Jul 2008 08:39:56 -0500
Reposting.. due to overquote. Apologies for multiple emails, if the first one make it to the list..
> Can you please print stack trace of the trace file ? or send me first 100
> lines of trace file?
> Also, what is your sga_target is set to? Do you use ASMM? What is your
> There are many reasons for ORA-4031 errors and easier to debug if we can
> get full ORA-4031 error and stack from the trace files etc.
> Douglas Cowles wrote:
>> The errors to appear to be citing the "shared pool" - which raises the
>> question, doesn't flushing the shared pool defragment the shared pool?