Prev: dropping a column in a production database
Next: Urgent openings ...get a refund
From: MikeHT on 2 Jul 2008 08:53
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
From: joel garry on 2 Jul 2008 16:23
On Jul 2, 5:53 am, MikeHT <mike2...(a)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/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
From: MikeHT on 3 Jul 2008 08:48
On Jul 2, 4:23 pm, joel garry <joel-ga...(a)home.com> wrote:
> On Jul 2, 5:53 am, MikeHT <mike2...(a)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
 | 
Pages: 1
Prev: dropping a column in a production database
Next: Urgent openings ...get a refund