Unit_images & compiled_unit_sections taking up too much memory

Help Workload Profiling
1

Hi Guys,

Currently We have S-00 plan, unit_images & compiled_unit_sections is taking up almost 1 GB each. We are not sure why. May be our plan expiration is 12 Hours.

What data does this memory holds and what all factors affect it? We want to basically reduce memory consumption of this as much as possible.

2

Hi Bhaskar,

Thanks for the post in the forum.

If you don’t need the plans then run the following command to evict the plans.

set global plan_expiration_minutes=0;

To remediate this you can change it to 6 hours or less based on your requirement.

Note: Always try this on Non-Prod systems first and do a thorough sanity check before implementing anything in Production.