SQL> select pid, program from v$process where program like '%LGWR%';
----------------------------------------------------------------------------------------
SQL> SELECT p.spid, s.program
2 FROM v$session s, v$process p
3 WHERE s.paddr=p.addr
4 AND s.program LIKE '%LGWR%';
2 FROM v$session s, v$process p
3 WHERE s.paddr=p.addr
4 AND s.program LIKE '%LGWR%';
------------------------ ------------------------------------------------
26803 oracle@orcl11gR2.us.oracle.com (LGWR)
ps -ef | grep 26803 | grep -v grep
oracle 26803 1 0 Jan 14 ? 2:11 ora_lgwr_ORCL11GR2
oracle 26803 1 0 Jan 14 ? 2:11 ora_lgwr_ORCL11GR2
No comments:
Post a Comment