Re: Check Active Users on 8.1.5 Database
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 11 Oct 2000 19:09:00 +0800
Message-ID: <39E44A4C.62A7_at_yahoo.com>
Date: Wed, 11 Oct 2000 19:09:00 +0800
Message-ID: <39E44A4C.62A7_at_yahoo.com>
Rayfil Cheung wrote:
>
> Hi,
>
> How can I check the active users connecting to the 8.15 database. Thank
> you.
select username, status
from v$session
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk (faster/mirrored at http://www.oradba.freeserve.co.uk) Its not the voices in my head that bother me... its the voices in yours.Received on Wed Oct 11 2000 - 13:09:00 CEST