Re: rman Ora-4031 - how to flush large pool?

Reposting.. due to overquote. Apologies for multiple emails, if the first one make it to the list..

> Douglas
>
> 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
> shared_pool_size?
> 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.
>
> cheers
> Riyaj

>
> 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?
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l