CODEWITHSUNDEEP
oracle-databasedatabase-cursor
Malfist
Malfist

Reputation: 31815

Possible complications for not closing database cursors?

What are the possible complications and repercussions if you do not close cursors for your Oracle database?

Upvotes: 2

Views: 705

Answers (1)

Justin Cave
Justin Cave

Reputation: 231821

Since your developers are complaining about the performance hit of repeatedly re-opening cursors, the proper solution in the database would be to close them in your code but set the session_cached_cursors parameter so that the database maintained a cache of the session's recently used cursors. Having them not close their cursors is going to cause the ORA-01000 error that you're seeing and will waste other server resources.

Upvotes: 4

Related Questions