Find Oracle sid and Linux pid

Oracle sid and Linux pidSometimes we found Oracle process that has been running too long using top command on Linux. We know it has PID. But how to know the SID of the process?Here is the script:selectsubstr(a.spid,1,9) pid,substr(b.sid,1,5) sid,substr(b.serial#,1,5) ser#,substr(b.machine,1,6) box,substr(b.username,1,10) username,substr(b.osuser,1,8) os_user,substr(b.program,1,30) programfromv$session...

Read More

Oracle:查詢誰Lock住Process, sid number ?做了什麼事？

ORACLE Tips: 查詢誰Lock住Process, sid number ?Oracle:10Gselect b.object_name obj_name,       d.ctime time,       to_char(d.lmode) l,       to_char(d.request) r,       a.os_user_name os_user,       c.machine machine,       c.program...

Read More