Kathy,
Ummmmmm, I think you missed my point. What I thought I said was we
found the shared_pool_RESERVE wasn 't getting used at all or hardly at all.
So we changed it from the default to 1M.
shared_pool_reserved_size string 1024000
shared_pool_size string 514400000
I don 't know how long your DB has been up but it looks like you had
85 failures and you still had 25M you never used.
The problem is Only allocations larger than
SHARED_POOL_RESERVED_POOL_MIN_ALLOC can allocate space from the reserved
list if a chunk of memory of sufficient size is not found on the shared
pool 's free lists.
Your query below says you had 25M free for something really big to
stick in the SharedPoolReserve but 4132 was smaller then the
SHARED_POOL_RESERVED_POOL_MIN_ALLOC so you got a 4031 when you had 25M free.
I didn 't say anything about changing the SHARED_POOL size.
It looks like you found the problem with .net.
What I 'm suggesting is you have 25M you might want to put to better
use somewhere else.
