using TFSSPUTL.SQL on Oracle 10

From: MikeHT <>
Date: Wed, 2 Jul 2008 05:53:07 -0700 (PDT)
Message-ID: <>

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'; "
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 Received on Wed Jul 02 2008 - 07:53:07 CDT

Original text of this message