Re: process information

Assuming the names of these processes are oracle<SID>, before they are killed you should be able to match their UNIX pid with the SPID column in v$process. These rows should correspond to v$session rows via the paddr column like so...

select * from v$session
where paddr = ( select addr from v$process where spid = <your_suspect_pid> );

-Kevin

"Josef Rick" <J.Rick_at_Debitel.net> wrote in message news:3BEC4E72.EE2FE8A4_at_Debitel.net...
> Hi,
> I'm looking for some information about a problem :
>
> We use a RS6000 running AIX to run Oracle 7.3 Server. Up to 20
> applikation run on the same system. And 50 to 100 Client's running
> ORACLE FORMS 4.0 on WinNT connect by network.
> The system woks fine, but from time to time we get a performance leak.
> There a up to 5 procees named oracle which takes a lot of cpu resources.
> Killing the processes the system goes on working fine. But we get no
> information about the processes. I only know they have a parent id 1.
> this means they are working for a crashed local process or they are
> working for a forms -network connection. Maybe parts of the network
> crashed, or the pc are switched off or something else happed. But how to
> proteced our server system ? so we need some information about the
> processes. But on which way. Hopefully someone know to determine some
> information about the problem .
> A lot of thanks
> J. Rick
> J Rick_at_debitel.net
>
>
Received on Fri Nov 09 2001 - 16:02:58 CST