Re: How to know who's logged on?

From: <hongs_at_lge.co.kr>
Date: 1997/08/04
Message-ID: <870686153.18114@dejanews.com>#1/1

In article <19970804010001.VAA02137_at_ladder01.news.aol.com>,   m4169_at_aol.com (M4169) wrote:
>
> Hi!
>
> Is there a view I can query from to find out which users are
> logged on to the oracle server?
>
> (some thing similar to sp_who in sybase)
>
> Thanks for any info.
>
> mamta

If you have the dba privilege, you may query the V$SESSION view.

---

Sungsook Hong
Oracle DBA
LG Electronics Inc.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Mon Aug 04 1997 - 00:00:00 CDT