excessive increase of sessions from client connections are generated and remained inactive for at le
may i know if there are documented reasons on having excessive increase of sessions per connections after an ORACLE database is patched to 10.2.0.4.
We have encountered this several times with no fail on our databases once it was patched. That's why we get ORA-12518: TNS:listener could not hand off client connection by the time the server can no longer handle the sessions.
Do you suggest any method of dealing with the error? Many thanks and hoping for your replies.
iReNe