Re: Count number of open cursors
Hi John,
Maybe a comparable stat for count might be to see the count of running threads:
SHOW GLOBAL STATUS like 'threads_running';
Assuming it is a 5.7+ server, to see the SQL I recommend:
SELECT * FROM sys.session;
You can also EXPLAIN these connections with EXPLAIN FOR CONNECTION n.
In earlier releases you can use SHOW PROCESSLIST.
Subject
Written By
Posted
Re: Count number of open cursors
July 06, 2017 10:05AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.