View running processes in Oracle DB
View running processes in Oracle DB This will show you a list of all running processes: SET LINESIZE 200 SET PAGESIZE 200 SELECT PROCESS pid, 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; Identify database SID based on OS Process ID use the following SQL query, when prompted enter the OS process PID: SET LINESIZE 100 col sid format 999999 col username format a20 col osuser format a15 SELECT b.spid,a.sid, a.serial#,a.username, a.osuser FROM v$session a, v$process b WHERE a.paddr= b.addr AND b.spid=&spid ORDER BY b.spid; For making sure you are targeting the correct session, you might want to review the SQL associated with the offensive task, to view the SQL being executed by the session you can use the following SQL statement: SELECT b.username, a.sql_text FROM v$sqltext_with_newlines a, v$session b, v$process c WHERE c.spid = &spid AND c.addr = b....