Re: session_Cached_cursors

Posted by ErmanArslansOracleBlog on Apr 25, 2019; 12:52pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/session-Cached-cursors-tp7343p7358.html

Yes. The parse count should be there.
session_cached_cursors eases parsing by by avoiding syntax and semantics checks.
However; parse count will be there for every execution.
As I said, those are pointer, so validity of the curors in the library cache (inside shared pool) should be checked every time.

However; if you use PLSQL block to execute the sql while session_cached_cursors is enabled, then things change. Because, PL/SQL can cache cursor handles in PL/SQL cache and hence reduce parsing.
So session_cached_cursors eases parsing in general, but reduces parsing only when the same SQL statements are submitted using PL/SQL.

here is a good article for you. I recommend you to review it ->

https://blog.toadworld.com/2017/05/11/session-cursor-caching-part-two