simple V$process PID question???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Mon, 29 Aug 2005 07:38:32 -0700 (PDT)
Message-ID: <20050829143832.52114.qmail@web60825.mail.yahoo.com>

We have ORALE 9ir2 and I tried to get PID info from v$process and it always show "no raws". Please give me a hint.

---

SQL> select * from v$process where pid ='12427';

no rows selected

SQL> select * from v$process where pid =12427;

no rows selected

SQL> select * from v$process where pid like '12427%';

no rows selected

SQL> exit

%ps -ef|grep 12427
  oracle 12586 12245 0 10:26:15 pts/2 0:00 grep 12427
  oracle 12427 1 0 10:19:42 ? 1:05 oracleRECODB (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))                 

---

Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs  

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 29 2005 - 09:40:29 CDT