In article <967812678.3570.0.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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
> >
Jerra, you may also find the osuser column in v$session useful instead
of the username column depending on if your processes are local or
remote.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 01 2000 - 08:38:41 CDT
