Re: How do check who is connecting to the database server?

David YEUNG wrote:
>
> In Oracle 8i, how can I find out who (and from where) is currenting
> to the database server, similarly to the Unix 'who' or 'w' commands?
> And as a 'SYS' user, how to kill a user connection?
>
> Thanks
>
> David Yeung

select * from v$session;

then

alter system kill session ...

-- 
Leon L. Zhang
Email: lzhang1_at_lucent.com