If you are looking for a query which will list you theĀ current open_cursors utilization and maximum limit in Oracle database, then try the below given query:

select max(a.value) as highest_value, p.value as max_value 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;

VN:F [1.9.12_1141]
Rating: 9.0/10 (2 votes cast)
VN:F [1.9.12_1141]
Rating: 0 (from 0 votes)
How to get current open_cursors utilization and maximum limit in Oracle, 9.0 out of 10 based on 2 ratings