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

Threaded View

  1. #1
    Join Date
    Apr 2001

    OS process id, v$session and v$process


    Pardon me if it's a simple question:

    Environment: Oracle 8i on solaris 8

    I notice a process is taking alot of CPU resources. By doing the "prstat" command at OS level, I've got its process id but would like to find out who it belongs to, from which it connects from and what action is it doing. I looked up v$process and found the process_id in "spid" column but v$process does not provide enough info. When I looked up v$session, I don't see which column is linked to v$process's column so I can join them together to find out more info.

    How do people usually find the information with only OS process id is known?

    Last edited by a128; 11-12-2002 at 09:49 PM.

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