How to Determine Oracle Session Information given UNIX PID ?

This will become useful when you notice that a db is consuming more time for response, all SQL and PL/SQL statements are running slow.
Now if you are in a Unix / Linux machine, you will issue the top command on the Unix.


Here you can see that CPU % used by 12231 is 90.9 % which might have caused my other server process to wait. If you want to determine what process or which Instance( if you have multiple instances in same machine) corresponds to this PID-12231, Issue the following query


Track or Tune the SQL issues by that session.

S S Nair

Oracle DBA/ Developer

http://ora-ssn.blogspot.com