Great response, thank you fellows for your replies. I would also like to share that when session_cached_cursors set, soft parsing can be reduced, resulting in reducing the cpu overhead for parsing the sql already present in shared pool.