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’