Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    USA/PA
    Posts
    6

    Unanswered: determing how many process are open

    Hi all,

    Is there a way I can query the data dictionary to find out how many process oracle is allowed to spawn? I was attempting to do it through sqlplus with V$Process but can't get the syntax right. Can anyone give a newbie a hand?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    v$license will give you max_sessions along w/ other info restricting concurrent sessions.
    I believe this might help.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    if you just want number of processes then:

    show parameter processes

    processes are directly related to semaphores in unix.
    not sure about windows.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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