Shared pool low
Hi team,
I have significant shared pool utilization in past few days in 12.1.0.2.0 EBS prod database.
Initially i had 2.1gb of shared_pool_size and SGA_TARGET size was 14.3GB. I have monitoring shell script which gives me current free space in shared pool.
Problem is that in last 3 days i had less then 10% free space of shared pool, so i track that growth and keep adding new size.
Currently i have these settings (SHARED POOL/SGA) after my actions:
shared_pool_reserved_size big integer 140928614
shared_pool_size big integer 3904M
lock_sga boolean FALSE
pre_page_sga boolean TRUE