ADDM, OPEN_CURSORS and SESSION_CACHED_CURSORS
The ADDM report that runs hourly is telling me to increase the open_cursors and session_cached_cursors. I already have those set pretty high (500 and 7000) but it keeps telling me the same thing. So I've been looking at v$sesstat and v$session to see how many cursors are open and being cached. In one example a session had 168 open and cursors and 69 were cached. When I looked at the open SQL in the session, most of the open cursors only had a count of 1 meaning they aren't being cached.
I am thinking that the problem (if it is indeed a problem) may be that because at the time I gathered this data there were 16 sessions open for the same user and they all are doing some of the same SQL but not all, none of the sessions are efficiently caching cursors. I understand that the next step is for Oracle to find the SQL in the shared pool.
I am thinking that the problem (if it is indeed a problem) may be that because at the time I gathered this data there were 16 sessions open for the same user and they all are doing some of the same SQL but not all, none of the sessions are efficiently caching cursors. I understand that the next step is for Oracle to find the SQL in the shared pool.
0