Find running processes in Oracle

Use following query to find running processing in Oracle. The output shows Process id of the running process, Status whether it is ACTIVE or INACTIVE, username, Schema Name and the SQL query that is running under current process.


SELECT sess.process,
       sess.status,
       sess.username,
       sess.schemaname,
       sql.sql_text
  FROM v$session sess, v$sql sql
 WHERE sql.sql_id(+) = sess.sql_id AND sess.TYPE = 'USER'

Running following query gives a handful of useful information.


SELECT *
  FROM v$session sess, v$sql sql
 WHERE sql.sql_id(+) = sess.sql_id AND sess.TYPE = 'USER'

Advertisements

,

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: