JDE/Oracle SQL error: maximum number of sessions exceeded

JDE/Oracle SQL error: maximum number of sessions exceeded


Scenario:

After performing SQL actions (insert/select/update) a reoccurring error started to appear and some SQL actions error.

Issue:

All Oracle session state objects are in use.

EXTOL error message:


[ERROR] ORA-00018: maximum number of sessions exceeded



Resolution:

Request DBA make updates to the DB Settings for : Processes, Sessions, and Transactions.

  • Processes=500
  • Sessions=1000
  • Transactions=1200



By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.