Re: diconnect all user at specific time

Try this if u r 8i or above

alter system disconnect session 'sid,serial#' post_transaction;

This waits till all transactions are completed for the sessions. If there a transaction which needs a large time to rollback, u will have to wait for that even after killing that session.

--
Posted via dBforums
http://dbforums.com