Re: Count number of open cursors
Posted by: Morgan Tocker
Date: July 06, 2017 10:05AM

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.

Options: ReplyQuote

Written By
July 06, 2017 03:01AM
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.