DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: How to find the actual number processes being used.

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    How to find the actual number processes being used.

    How do I find the actual number of processes used after the fact that the application has finished running.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    will it help?

    select * from v$process;

  3. #3
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    I ran an app and I am trying to find out how many processes have been actually used during its past run.

    I thought v$process gives the current number of processes at any given time. Do I need to findout all the session id's the app was logged into during the run and put that into v$process?

  4. #4
    Join Date
    Jan 2002
    Posts
    50
    Hi,
    Joining V$session and V$process
    will provide u the session ID and OS process that session is using. Not the application. I think u need which process are running your application , wright???

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    If i read you correctly you mean that the app has finished and you want to know how many processes it took?

  6. #6
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    Yes. I am trying to tune the number of processes in init.ora and I am trying to find out what are the maxium number of process app (load runner) had used.

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can see session_highwater in v$license.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

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


Click Here to Expand Forum to Full Width