具备什么条件的cursor被缓存在pga中，成为session_cached_cursor

repentance

看Maclean的v$open_cursor文章有些地方没看懂，通过java程序执行了1000多次同一个语句，为何这个cursor没有成为session_cached_cursor，那什么情况下cursor会成为pga中的 session_cached_cursor呢？
Maclean文章http://www.oracledatabase12g.com/archives/about-dynamic-view-open_cursor.html

Maclean Liu(刘相兵

ODM Data:

SESSION_CACHED_CURSORS  will cause closed cursors to be cached within the session so that a subsequent call to parse the statement will bypass the parse phase. This is similar to HOLD_CURSORS in the precompilers. One point to be careful about is that if this parameter is set to a high value, the amount of fragmentation in the shared pool may be increased. Another thing to note is that if the value of this parameter is less than the cursors that are closed before the first one is reopened, you will never see the benefit of the cache since the first cursor would have been aged out already.

As maclean said:

A cursor should be either an open cursor or session cached cursor , not both

After you have closed the cursor , it may become  session cached cursor , If it satisfied the requirement  .

repentance

received with thanks!