use of shared_pool_reserved_size

Hi,

I didn't get an answer on the other so hopefully somebody can help me,

TIA, Jeroen

-----Oorspronkelijk bericht-----
Van: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam_at_vrijuit.nl] Verzonden: Monday, November 09, 1998 12:35 PM Aan: 'oracledba_at_mailinglist.net'
Onderwerp: use of shared_pool_reserved_size

Hi,

I'm experimenting with shared_pool_reserved_size and some strangs things happen.
Oracle 7.3.4, MTS, HP-UX 10.20

shared_pool_size=70M
shared_pool_resered_size=15M
shared_pool_reserved_min_alloc=10000 (bytes I assume, so 10K)

When I recompile all PL/SQL stuff. These differ in size from 7,8 K up to

900K (yes I know ridiculous !)

When I try to check what happens with
dbms_shared_pool.sizes(10) or
select from v$db_object_cache

I see all procedures loaded, around 1060 rows from v$db_object_cache. When I query v$shared_pool_reserved I get zip, only free_space 15M and free_count 1. I would assume that used_space and used_count, requests would be
incremented. Why is this, it looks that the're all loaded in regular shared_pool ?
Is the min_alloc in Kb ? Can I use other stuff to check this ?

Thanks in advance,

Jeroen Received on Tue Nov 10 1998 - 05:54:18 CST