Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PERL DBI: ORA-01000 Maximum open cursurs exceeded
- Thread starter h011ywood
- Start date
I think this needs to be configured on the Oracle Server, and isn't a DBI issue, just that the DBI is reporting it
HTH
--Paul
in plainspleak, the server has too many open sessions - check this up on an Oracle Forum, actually searching for the ORA-01000 string on a search engine should yield results
HTH
--Paul
in plainspleak, the server has too many open sessions - check this up on an Oracle Forum, actually searching for the ORA-01000 string on a search engine should yield results
Paul is correct.
But more importantly, what is the max and why are you hitting it? You may want to investigate why you have so many open handles (assuming that your oracle max connections is not insanely low).
Proper db handle caching should keep connection counts low, even on high traffic systems.
But more importantly, what is the max and why are you hitting it? You may want to investigate why you have so many open handles (assuming that your oracle max connections is not insanely low).
Proper db handle caching should keep connection counts low, even on high traffic systems.
- Status
Similar threads
