Database Administration (MOSC)

MOSC Banner

Should I decrease Open_Cursors?

edited May 18, 2015 2:43AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hello. I'm new in Oracle DBA world. In task, my work friends offered to decrease open_cursors from 1000 to 400. In database maximum cursors is 22. So Should we decrease ? and Can we get performance in database when we decreased? Thanks. (We use Oracle 12c, ODA machine)


SQL> select
  max(a.value) as hwm_open_cur,
  p.value as max_open_cur
from
  v$sesstat a,
  v$statname b,
  v$parameter p
where
  a.statistic# = b.statistic#
and
  b.name = 'opened cursors current'
and
  p.name= 'open_cursors'
group by p.value;

HWM_OPEN_CUR              MAX_OPEN_CUR
------------          -------------------
22                           1000


Message was edited by: 2892034

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