Should I decrease Open_Cursors?
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