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
