Posts tagged open_cursors

How to get maximum limit of open_cursors, sessions and processes in Oracle

0
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’

How to get current open_cursors utilization and maximum limit in Oracle

0
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 [...]
Go to Top