Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home4/blessonj/public_html/blog/wp-content/plugins/keywords-cloud-for-wordpress/keywords-cloud.php on line 397

Warning: mysql_real_escape_string(): A link to the server could not be established in /home4/blessonj/public_html/blog/wp-content/plugins/keywords-cloud-for-wordpress/keywords-cloud.php on line 397

Posts Tagged open_cursors

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

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: , , ,

How to get current open_cursors utilization and maximum limit in Oracle

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)

Tags: ,