using TFSSPUTL.SQL on Oracle 10
Date: Wed, 2 Jul 2008 05:53:07 -0700 (PDT)
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
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