Re: Unix - Top identifying processes in Oracle

v$session.paddr equals v$process.addr

Hth,

Sybrand Bakker, Oracle DBA

"Jerra" <jerra_at_aland.net> wrote in message news:8oo5d9$218$1_at_gandalf.alcom.aland.fi...
> I can see Oracle processes that take more resources than others in Top.
> With the Top's PID the process can be viewed in v$process.
>
> Is it possible to get some relation to v$session from v$process?
>
> The problem is that all apps connect as the same user to the database so
> it's not possible to identiy them by username.
>
>
> Anyone got any ideas?
>
>
> /Jerra
>
>
>
Received on Fri Sep 01 2000 - 07:07:08 CDT