Regarding Max open cursors exceed
Posted on 2004-08-26
The cursors that exceeded the limit of database, there by hanging the database server.
Open_cursors = 150
cursor_space_for_time = FALSE.
I request u don't suggest to increase open_cursors parameter
Can you please tell me of any other Oracle functionality available that
will allow me to clean up the cursor details that are currently opened in the database
even my application closes.