Re: shared_pool_reserved_size and sga
- From: Ram Raman <veeeraman@xxxxxxxxx>
- To: Andreas Piesk <a.piesk@xxxxxxx>
- Date: Thu, 19 Aug 2010 17:49:54 -0500
I was looking for objects with SHARABLE_MEM > 100000. FYI
On Thu, Aug 19, 2010 at 4:59 PM, Ram Raman <veeeraman@xxxxxxxxx> wrote:
>
> Thanks Andreas. All of them are cursors.
>
> On Thu, Aug 19, 2010 at 4:47 PM, Andreas Piesk <a.piesk@xxxxxxx> wrote:
>
>> Ram Raman schrieb:
>> > Querying shared_pool_reserved view after the bounce an hour ago shows us
>> > that the request failures is 28. Our sga target is 4.5Gb now.
>>
>> i had a similar problem some time ago. which part of shared_pool grows?
>>
>> -ap
>>
>
>
Other related posts:
