Win a copy of Spark in Action this week in the Open Source Projects forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

too many open cursors

 
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
 
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
 
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
 
Does this tiny ad smell okay to you?
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic