Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cause: open_server_files failed due to ORA-01000: maximum open cursors exceeded.

Beauty_and_dBestMay 11 2020 — edited May 15 2020

12c

OL7

Hi ALL,

We have a package 3rd party app, that hits ORA-01000.

i already increased our open_cursors from 1000 to 5000, but it still hitting error.

I understand this package is using for-loop that will explicitly closing a cursor.

I am suspecting it hits is a database bug that is not explicit closing a cursor?

Is there a history v$ table where I can query what specific sql program is eating a lots of cursor?

Please help....

Kind regards,

Added on May 11 2020

#general-database-discussions

65 comments

1,937 views