we had an issue in our live system. All JDBC sessions are going to inactive state and following error is coming server logs.
2016-01-07 16:34:42 GMT [ISS.0128.0001E] Unable to get JDBC connection. Exception:Error Message: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
; Error Code: 604; SQLState: HY008
2016-01-07 16:34:42 GMT [ISS.0137.0018E] Scheduler: Exception while invoking ‘wm.server.dispatcher:deleteExpiredUUID’: Failed to remove the expired entries from the document history table. See server log for details.
Please advise us why this error is happening.