Dear Gurus,

For the past few days we are getting the following
error especially when users open LOVs in forms.

Ora-04031: unable to allocate nnnnn bytes of shared memory

I have recently joined as dba and to remove some
internal error codes installed 8.1.7.4.1 patchset
which has also taken care of persistent 100% CPU
utilization problem.

Now I am looking into the memory
parameters and need ur advice / help on configuring
the shared pool and also how to avoid this problem.

Currently I query the db for users utilizing most
memory and kill the sessions on top

Our current db platform is:
DB 8.1.7.4.1
OS Windows NT 4 (SP 6)

Memory Installed 2 GB
Availaible Memory 900 MB

SHARED_POOL_SIZE = 400 MB
SHARED_POOL_RESERVED_SIZE = 50 MB
LARGE_POOL_SIZE = 250 MB
SORT_AREA_SIZE = 200 MB
SORT_AREA_RETAINED_SIZE = 100 MB


Best Regards,

Kashif