Re: using TFSSPUTL.SQL on Oracle 10

From: MikeHT <mike2.li_at_gmail.com>
Date: Thu, 3 Jul 2008 05:48:52 -0700 (PDT)
Message-ID: <b76ba89d-fba9-46c0-8c1d-ef13ccf6fd3b@y21g2000hsf.googlegroups.com>


On Jul 2, 4:23 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 2, 5:53 am, MikeHT <mike2..._at_gmail.com> wrote:
>
>
>
>
>
> > On the Oracle 10 DB:
> > SHOW PARAMETER shared_pool_size;
> > Is returning 0 because it is not set
>
> > How to update script TFSSPUTL.SQL to get "Shared pool allocation
> > (actual)"
> > I tried replacing " select value into pool_size from v$parameter where
> > name='shared_pool_size'; "
> > with
> > select sum(bytes) into pool_size from v$sgastat where pool='shared
> > pool';
>
> > But I get Percentage utilized for shared pool > 100
>
> > Ideas to get an accurate pool_size in Oracle 10?
>
> > Thank you
>
> That script is for O7???
>
> Please note that the docs explain a lot:http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initpa...
>
> select * from v$sgastat where pool like '%d poo%';
> select sum(bytes) from v$sgastat where pool like '%d poo%';
> SELECT * FROM V$SGASTAT
>  WHERE NAME = 'free memory'
>    AND POOL = 'shared pool';
>
> I'm always forgetting the part about rounding it up to next granule
> size.
>
> jg
> --
> @home.com is bogus.
> Those darn hackers!  http://www.signonsandiego.com/uniontrib/20080702/news_1b2atm.html- Hide quoted text -
>
> - Show quoted text -

Thanks.
Is there sql to find out
% utilization of SGA_MAX_SIZE
% utilization of SGA_TARGET Received on Thu Jul 03 2008 - 07:48:52 CDT

Original text of this message