Wednesday, June 9, 2010

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



Post a Comment


ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com