Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

too many open cursors

 
Lars Vegas
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I've a big problem with Oracle/Borland classes. Im using the borland class QueryDataSet. That class has a method closeStatement(), which is supposed to close the open cursor on the database. but it doesn't seem to work. The open cursors remain open. so, after a while I get the big bang. Has anyone experience with problems like this? Or, if not, how can I close the open cursors although I don't know the names of the not-active cursors?
Any help appreciated.
Lars
 
Asif Equbal
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The problems sems to be with the init.ora file setting .
Change ur init.ora parameter names max_open_cursor = 200 ( default it is 50) .
i think this will do the Job

------------------
Asif Equbal
Cognizant Technology Solutions , India.
 
Lars Vegas
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for trying to help. But I don't want to raise the allowed maximum of open cursors, because it will lower performance. I want to close the open cursors, that are not needed anymore!!!
 
Lars Vegas
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for trying to help, but I don't want to raise the allowed number of open cursors, I want to close the not needed open cursors. In my application even 200 open cursors won't be enough. And I cannot raise to 5000. I need performance and I just don't want to keep these cursors!!!
Lars
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
close the resultset and the statement.
Regards
Beksy
 
Lars Vegas
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I cannot close the statement, because the function closeStatement() from the Borland class QueryDataSet is NOT working!!! The function does not close the statement. And replacing the whole Borland stuff is not possible anymore in short time!!!
Any help still appreciated.
Lars
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic