Hello Prafful,

In our system the SHARED_POOL_RESERVED_SIZE is 5% of the SHARED_POOL_SIZE.

shared_pool_reserved_size ---> 31457280
shared_pool_size ---> 629145600

Select Free_space,avg_free_size,max_free_size,
used_space,avg_used_size,max_used_size,request_misses,request_failures from V$SHARED_POOL_RESERVED;

FREE_SPACE -------> 28,870,680
AVG_FREE_SIZE ----> 45,681
MAX_FREE_SIZE ---> 25,818,224
USED_SPACE ------->
AVG_USED_SIZE ---> 2,586,600
MAX_USED_SIZE ---> 4,093
REQUEST_MISSES --> 0
REQUEST_FAILURES-> 0

By looking at the above values approximately 28MB (FREE_SPACE) of the SGA is getting wasted.

How can we avoid this?

Thanks,
Nikee