To see if you have set OPEN_CURSORS high enough

Database Performance Tuning & Optimization
Post Reply
User avatar
jimb
Site Admin
Posts: 6146
Joined: Thu Jan 19, 2012 1:10 pm
Location: New Delhi, India
Contact:

To see if you have set OPEN_CURSORS high enough

Post by jimb »

SELECT MAX(a.value) AS highest_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;
Oracle Database Administration Forums
http://www.oracle-forums.com/
xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: To see if you have set OPEN_CURSORS high enough

Post by xaeresis »

xaeresis
Posts: 196117
Joined: Wed Oct 04, 2023 2:39 pm

Re: To see if you have set OPEN_CURSORS high enough

Post by xaeresis »

Post Reply