In order to display the maximum limit of open_cursors, sessions and processes in Oracle, you can run the below queries on SQL Plus:

select value from v$parameter where name = ‘open_cursors’

select value from v$parameter where name = ‘sessions’

select value from v$parameter where name = ‘processes’

VN:F [1.9.12_1141]
Rating: 8.5/10 (4 votes cast)
VN:F [1.9.12_1141]
Rating: +2 (from 2 votes)
How to get maximum limit of open_cursors, sessions and processes in Oracle, 8.5 out of 10 based on 4 ratings