Re: Check Active Users on 8.1.5 Database
From: <joseharvey_at_my-deja.com>
Date: Wed, 11 Oct 2000 10:48:19 GMT
Message-ID: <8s1ghj$uv2$1_at_nnrp1.deja.com>
Date: Wed, 11 Oct 2000 10:48:19 GMT
Message-ID: <8s1ghj$uv2$1_at_nnrp1.deja.com>
In article <39E43E55.E0E7169F_at_forward-hk.com>,
Rayfil Cheung <rayfil_at_forward-hk.com> wrote:
> Hi,
>
> How can I check the active users connecting to the 8.15 database.
Hi,
try the following connect (with dba permissions):
select sid, serial#, osuser, username, machine from v$session where type
= 'USER';
The first two values allow you to kill the specified session:
alter system kill session '<SID>,<SERIAL#>';
Cheers,
Jose
-- -=[ Sancho ]=- Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Oct 11 2000 - 12:48:19 CEST