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.0/10 (3 votes cast)
VN:F [1.9.12_1141]
Rating: +1 (from 1 vote)

Tags: , , ,