Home » RDBMS Server » Performance Tuning » Cursor time out error(open cursor on bottleneck)
Cursor time out error(open cursor on bottleneck) [message #190809] Fri, 01 September 2006 06:29 Go to next message
Messages: 18
Registered: August 2006
Location: Ahmedabad
Junior Member
Dear All,

I am facinng one major problem "Cursor Time Out Error". Around max 1000 users simultaneously accessing My Application. First our open_cusor value was 400. But day by day we have increased value upto 1800 due to more user connections and cusor time out error.
Still we are facing same problem. We have just one month before implemented our application. And even we took care in application that we have appropriately closed our connection. App is in JAVA/Oracle.

And even I consult the other DBAs, So at database level we set parameter with optimum value. We have analysed our DB parameters.

So we can do now. So, Is there problem in application coding or from database side(did not set parameter value appropriate).

Paresh Rupareliya
Re: Cursor time out error(open cursor on bottleneck) [message #190888 is a reply to message #190809] Fri, 01 September 2006 20:48 Go to previous message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
Your search - "Cursor Time Out Error" - did not match any documents.
Please post the actual Oracle error message along with the ORA-???? code.
Since Google return ZERO hits, I assume what you posted was your Application error message; which is only meaningful to your programmers.
Previous Topic: Performance tuning SQL
Next Topic: Access to the database is very slow.
Goto Forum:

Current Time: Sun Aug 20 10:29:58 CDT 2017

Total time taken to generate the page: 0.05748 seconds