Database Administration (MOSC)

MOSC Banner

How to adjust "Current Open Cursors Count" metric.

edited May 5, 2020 5:11AM in Database Administration (MOSC) 12 commentsAnswered ✓

Today I received first time warning for metric.

Metrics "Current Open Cursors Count" is at 1,228.

I did not receive any "ORA-01000 maximum open cursors exceeded". The number of Open Cursors per session is as high as 72.

I understand that this metric is different than Open Cursors per session.

I want to understand and adjust this metric for my database.

My question is :

1) What exactly does it count?

2) How can I see the current value of "Current Open Cursors Count".

Monitoring the current value can help me adjust the metric.

Thanks in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center