1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice
rajabtambwe

Sniped sessions and ora-00020: maximum number of processes (%s) exceeded 2011-03-23

Sniped sessions and ora-00020: maximum number of processes (%s) exceeded

  1. rajabtambwe
    When you implement the resource limit, the sessions that exceed the IDLE limit is marked as SNIPED in V$SESSION view and you may get “ORA-00020: maximum number of processes (%s) exceeded” error because Oracle doesn’t kill that session in OS level and it assumes it as a “process”. So for this, you need to kill those sessions manually.

    This Document shows a little demonstration of the whole process: – First of all, set the RESOURCE_LIMIT parameter to TRUE to enforce the resource limit in database profiles