查看佔用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';