shared pool:too large miscellanceous part

[mjsi]

My oracle ever reported ora-04031 error.
v$sgastat like that:

POOL NAME BYTES
----------- -------------------------- ----------
shared pool VIRTUAL CIRCUITS 355184
shared pool sessions 413440
shared pool sql area 499160
shared pool event statistics per sess 590240
shared pool library cache 779736
shared pool db_block_hash_buckets 803312
shared pool db_block_buffers 3993600
shared pool miscellaneous 46841096
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
shared pool free memory 323170248

I noticed that the miscellaneous part is very large and the value is always growing. Is there some problem with it? what should I do ?Can I decrease it and how?

[jkoopmann]

shared pool miscellaneous is the sum of everything that is too small to have its' own line item in v$sgastat.

therefore it is accumulative and there until you bounce the database.

there is a standing bug open within oracle, Bugs 1921561, 1704094, 1193003, 1318267, etc. (all internal), 1397603, 1640583 (all external) have been filed for similar scenarios; also, see Oracle Doc 146599.1

what version are you on? seems there have been some patch fixes

a few workarounds that have been posted are: (use with caution )
set: STAR_TRANSFORMATION_ENABLED=FALSE
remove LARGE_POOL_SIZE parameter in the INIT.ORA file

i have attached a file for help in resolving ora-04031 errors.

[jkoopmann]

try the attachment again

[mjsi]

Thank a lot! Your advice is very helpful. I will try it ASAP.
Good luck to you all!