BenBart wrote:
> Hi all,
>
> Is it possible to check via the V$ views which client PC is using which sessions, i.e. IP ADDRESS wise?
>

select username, machine from v$session

will give you the hostname (and windows domain if applicable) that you
can then look up in DNS. You can also get serial# and sid from that same
view if you want to track sessions with those.

Steve


Oracle LazyDBA home page