Database Administration (MOSC)

MOSC Banner

ORA-01000: Maximum Open Cursors Exceeded

in Database Administration (MOSC) 4 commentsAnswered

Hello All,

In my env we are using Oracle 19c SE2 on RHEL8

On an intermittent basis I have been observing we are getting ORA-01000: Maximum Open Cursors Exceeded error recorded in the alert log file.

But as the session is getting killed/exiting the DB by the time we login to check which session is causing this error.

Would like to know how should i get to Root cause (know for sure this is an application prob) with the help of statspack report?

what areas of the statspack report would give me a hint on which session/user is causing this issues so that i can get back to application team with the req info.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center