I'm facing a pretty intermittent issue related to oracle cursor leak. Our system runs on oracle 12.2.0.1 database. As per the oracle documentation suggested we recently upgraded our oracle connection pool to universal connection pool( also ojdbc7 to ojdbc8, ucp and ons ), since oracle data source has some deprecated functions comparing with our database. After doing this i'm facing a cursor leak in a query which is worked for many years back. We have maximum of 3000 cursors declared in our system and after starting a one app server cursor limit is getting excedded. Please give me a idea about this.
Note: I can update this with the databse information if needed.