oracle数据库session对应进程,[请教] 如何根据数据库的session ID确定其对应的OS 进程号...

QL>

SQL>       SELECT view_definition FROM v$fixed_view_definition

WHERE view_name='GV$LOCKED_OBJECT';

2

VIEW_DEFINITION

--------------------------------------------------------------------------------

select x.inst_id,x.kxidusn, x.kxidslt, x.kxidsqn, l.ktadmtab,        s.indx, s.k

suudlna, s.ksuseunm, s.ksusepid, l.ksqlkmod from x$ktcxb x, x$ktadm l, x$ksuse s

where x.ktcxbxba = l.kssobown and x.ktcxbses = s.addr

SQL> SELECT view_definition FROM v$fixed_view_definition

2  WHERE view_name='GV$PROCESS';

VIEW_DEFINITION

--------------------------------------------------------------------------------

select inst_id, addr,indx,ksuprpid,ksuprunm,ksuprser,ksuprtid,ksuprpnm, ksuprtfi

, decode(bitand(ksuprflg,2),0,null,1), decode(ksllawat,hextoraw('00'),null,kslla

wat), decode(ksllaspn,hextoraw('00'),null,ksllaspn), ksuprpum,ksuprpnam+ksuprpra

m,ksuprpfm, case when ksuprpnam+ksuprpram > ksuprpmm       then ksuprpnam+ksuprp

ram       else ksuprpmm end  from x$ksupr where bitand(ksspaflg,1)!=0

SQL>  SELECT view_definition FROM v$fixed_view_definition

2         WHERE view_name='V$PROCESS';

VIEW_DEFINITION

--------------------------------------------------------------------------------

select addr, pid,spid,username,serial#,terminal,program,traceid,background, latc

hwait,latchspin,pga_used_mem,pga_alloc_mem,pga_freeable_mem,pga_max_mem from gv$

process where inst_id = USERENV('Instance')

SQL>  SELECT view_definition FROM v$fixed_view_definition

2         WHERE view_name='v$LOCKED_OBJECT';

no rows selected

SQL>  SELECT view_definition FROM v$fixed_view_definition

2         WHERE view_name='V$LOCKED_OBJECT';

VIEW_DEFINITION

--------------------------------------------------------------------------------

select xidusn,xidslot,xidsqn,object_id,session_id,oracle_username, os_user_name,

process,locked_mode from gv$locked_object where inst_id = USERENV('Instance')

SQL>