using TFSSPUTL.SQL on Oracle 10
From: MikeHT <mike2.li_at_gmail.com>
Date: Wed, 2 Jul 2008 05:53:07 -0700 (PDT)
Message-ID: <3ddcaa2c-49e9-4258-9df7-b1e1887bf915@s50g2000hsb.googlegroups.com>
Date: Wed, 2 Jul 2008 05:53:07 -0700 (PDT)
Message-ID: <3ddcaa2c-49e9-4258-9df7-b1e1887bf915@s50g2000hsb.googlegroups.com>
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 Received on Wed Jul 02 2008 - 07:53:07 CDT