cursor cache - cheeyoung/sqlplus-public GitHub Wiki

session cursor cache

2.325 SESSION_CACHED_CURSORS

Repeated parse calls of the same SQL (including recursive SQL) or PL/SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Oracle uses a least recently used algorithm to remove entries in the session cursor cache to make room for new entries when needed.