Thanks for the update Thomas.

I have identified the objects (especially Indexes) which are causing problem. I am working to fix them one by one.

CPU utilization is maximum 30% I have seen so far. We are ASMM so Oracle manages the memory allocation. Regarding error in v$sga_resize_ops, Oracle addressed it in Metalink ID 556928.1. May be I need to bounce my DB to wake up MMAN again.

Thanks,