Skip to main content
Needs Votes

Monitor Oracle database cursors

Related products:Infra Monitoring - Connectors
  • Jun 17, 2025 9:46 AM UTC
  • 5 replies
  • 137 views

Forum|alt.badge.img+2

To prevent the dreaded ORA-01000 error, would it be possible to add a cursor mode to Oracle plugin ?

 

Some doc here: https://www.rshankar.com/how-to-find-out-maximum-open-cursors-and-no-of-cursors-open-in-oracle/

 

Thx

5 replies

ltirand
Centreonian
Forum|alt.badge.img+13
  • Centreonian
  • Jun 25, 2025 7:35 AM UTC

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


rchauvel
Centreonian
Forum|alt.badge.img+18
  • Centreonian
  • Jul 11, 2025 12:12 PM UTC
New→Discussion ongoing

rchauvel
Centreonian
Forum|alt.badge.img+18
  • Centreonian
  • Sep 5, 2025 12:18 PM UTC

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


Forum|alt.badge.img+6

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


Forum|alt.badge.img+5
  • Centreonian
  • Dec 11, 2025 3:24 PM UTC
Discussion ongoing→Needs Votes