Re: rman Ora-4031 - how to flush large pool?
- From: "Riyaj Shamsudeen" <riyaj.shamsudeen@xxxxxxxxx>
- To: dcowles@xxxxxxxxxx
- 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..
> 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?
>>
>>
>>
Other related posts:
