Monitor Oracle database cursors

Hello :)

If I understand correctly, this mode would monitor the following metrics:
- maximum number of cursors allowed per session
- cursors currently open in your session
- cursors usage by session

with thresholds on the number of cursors open in your session and thresholds on cursors used in each session?

Kind regards

​@Jean-François Rameau can you please detail your need as requested by ​@ltirand ?

Hi,

For query the usage of cursors in entire database, I just created a view and query this view using App-DB-Oracle-Sql

select * from  sys.percentual_cursores;

CREATE VIEW "PERCENTUAL_CURSORES" ("P_CURSORES") AS
  (
select
   max(a.value)/p.value*100 p_cursores
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
);

W'll be great if this be implemented in the native Oracle Database Plugin Connector