Coba pakai script ini : ALTER SYSTEM FLUSH SHARED_POOL; rgds, kusnandar rohim
________________________________ From: Moch Firman N <[email protected]> To: [email protected] Sent: Wednesday, June 10, 2009 4:23:47 PM Subject: Re: [indo-oracle] Re: How to capture Shared Memory Usage ? Thanks tuk info nya, btw, klw sintak tuk me-reset shared memory usage ? thanks Piping On Wed, Jun 10, 2009 at 3:30 PM, Yulius Wibowo <yulius_wibowo@ yahoo.com>wrote: > > > Semoga membantu... > > SQL> select name, type, SHARABLE_MEM from V$DB_OBJECT_ CACHE > where name in ('PKG_A','PKG_ B'); > > cmiiw, > bw > > > --- In indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com>, Moch > Firman N <mochfirman@ ...> wrote: > > > > Dear All, > > > > > > Gimana cara nya untuk meng-capture shared memory usage antara package A > dan > > package B ? > > > > Please your advise... > > > > > > > > > > Thanks and best regards > > Piping > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
