oracle pid查看,查看佔用aix oracle pid

1.在aix 打topas查看哪個oracle佔用高資源,如

Name             PID   CPU%   PgSp Owner

oracle       8196148   14.9    4.6 oracle

2.在sql查看unix pid 8196148,

SELECT p.pid,p.spid,s.sid,p.username,s.TYPE,

s.SERIAL#,s.SCHEMANAME,s.OSUSER,s.MACHINE,

s.PROCESS,p.PROGRAM,s.MODULE,s.STATUS,

s.terminal,logon_time

FROM v$process p, v$session s

WHERE p.addr=s.paddr

and spid ='8196148';

3.發現如他是不重要或是卡死的,可以直接kill

alter system kill session '343,46823' .

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

SELECT p.pid,p.spid,s.sid,p.username,s.TYPE,

s.SERIAL#,s.SCHEMANAME,s.OSUSER,s.MACHINE,

s.PROCESS,p.PROGRAM,s.MODULE,s.STATUS,

s.terminal,logon_time

FROM v$process p, v$session s

WHERE p.addr=s.paddr

ORDER BY status,logon_time,status;

alter   system kill session 'SID,Serial';