Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: maximum number of processes - is there a high water mark history for this info

    Hi,

    I get "ORA-00020: maximum number of processes (150) exceeded" in my application log.

    I know I should enlarge the processes initiation parameter.
    I would like to know if there is a place (i.e. v$ table) I can look in and find what was the maximum connection number in the last "x" days/hours etc'

    Idea, anyone?

    Thanks,

    Tal Olier ( otal@mercury.co.il )

  2. #2
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Trigger

    Hi
    I am not sure if there a way to track that information.
    You might wanna consider creating a trigger in this case, which would log that event (<150 processes). I am not sure how to do that, but just a suggestion.
    Thanx and Regards
    Aruneesh

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Try v$resource_limit which will tell you the highest number of processes since database startup. I dont think you can clear it down though except by shutdown.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •