Re: defragment shared pool

ls cheng wrote:
>
> Hi
>
> If we face ORA-4031 will
>
> alter system flush shared_pool
>
> defragment (coalesce) thee free chunks?
>
> I understand that in Oracle 7 this command was useless to coalesce or
> defragment the shared pool (at least this is what Metalink's Note
> suggests). However in Oracle 8 and 8i does it still apply or it's
> improved and we can fix ORA-4031 (temporary solution) by flush the
> shared pool manually OR does Oracle defragment shared pool internally?
>
> Also is there any X$ view that shows the free chunks remaining with
> their respective sizes? (I will try with a small shared pool of
> course! If such x$ exists)

pre 8.1.6 there was occasionally some benefit if your app did nasty things (like not use bind variables).

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."