RE: Monitoring Unix Question

2002-11-16 Thread ecandrietta
<> ' ' > / > > > > -----Original Message- > > From: ecandrietta [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 14, 2002 1:20 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Monitoring Unix Question > > > > >

RE: Monitoring Unix Question

2002-11-14 Thread Stephen Lee
d s.username <> ' ' / > -Original Message- > From: ecandrietta [mailto:ecandrietta@;uol.com.br] > Sent: Thursday, November 14, 2002 1:20 PM > To: Multiple recipients of list ORACLE-L > Subject: Monitoring Unix Question > > > > Friends : > > Ho

Re: Monitoring Unix Question

2002-11-14 Thread Connor McDonald
In V$PROCESS there is SPID (or something similar) which is the OS pid. Then, you can join to V$SESSION on ADDR / PADDR hth connor --- ecandrietta <[EMAIL PROTECTED]> wrote: > > Friends : > > How can i do for get what is running inside a PID > that is > using a lot of CPU ? > > How can I get

Monitoring Unix Question

2002-11-14 Thread ecandrietta
Friends : How can i do for get what is running inside a PID that is using a lot of CPU ? How can I get the query that is running inside the database according PID of unix ? I would like to know commands of the unix and the query that i need to run in the database for find out the problem. Rega