Database - RAC/Scalability (MOSC)

MOSC Banner

Why session cursor cache count is over the session_cached_cursors parameter?

edited Nov 25, 2019 11:28PM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

SYS@DB>select * from (select  t.value ,s.sid, s.sql_id from v$sesstat t, v$statname n, v$session s where t.sid=s.sid and n.name= 'session cursor cache count' and t.statistic# = n.statistic#  order by 1 desc) where rownum <=10;   2    3    4     VALUE        SID SQL_ID ---------- ---------- -------------   3313121      3037     10744      2630       2380      1562       1846      2874       1843        827       1838      1234       1822        168       970        578       315        826       157        823 10 rows selected. SYS@DB>SYS@DB>SYS@DB>SYS@DB>show parameter cursor NAME                                TYPE        VALUE ------------------------------------ ----------- ------------------------------ cursor_bind_capture_destination      string      memory+disk cursor_sharing                      string      EXACT cursor_space_for_time                boolean    FALSE open_cursors                        integer    400 session_cached_cursors              integer    50 SYS@DB>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center