Re: Shutdown

select sid,serial#,osuser,program,to_char(logon_time,'mm-dd-yyyy hh24:mi:ss')
from v$session;

gives you who is connected.

alter system kill session '<sid>,<serial#>'; send kill session signal to user. THe process will be killed, and the user will have an message
'Your session has been killed';
Get sid ans serial# from the first list;

Diego Pafumi wrote:

> Hi gurus !!!
> I have a question. I have to shutdown my database, but sometimes some
> machines are connected. I want to do a "normal" shutdown. So the
> question is: How can I kill the users connected to my database????
> I saw in the v$session that there are users connected from more than 5
> days, so I want to kill their session.
>
> Thanks in advance and sorry about my English !!!
>
> Diego

--
Iosif Tanasescu
Consultant
The CGI Group Inc.
1800 McGill College, Suite 1600
Montreal, Quebec, Canada H3A 3J6
Tel: (514) 281-0149
Fax: (514) 847-0071
IIS:itanases
E_mail:Iosif.Tanasescu_at_BellSygma.com