Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

using TFSSPUTL.SQL on Oracle 10

0 views
Skip to first unread message

MikeHT

unread,
Jul 2, 2008, 8:53:07 AM7/2/08
to
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

joel garry

unread,
Jul 2, 2008, 4:23:20 PM7/2/08
to

That script is for O7???

Please note that the docs explain a lot:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams197.htm#REFRN10202

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

MikeHT

unread,
Jul 3, 2008, 8:48:52 AM7/3/08
to
On Jul 2, 4:23 pm, joel garry <joel-ga...@home.com> wrote:
> On Jul 2, 5:53 am, MikeHT <mike2...@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

0 new messages