Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script to kill all user sessions before shutdown immediate
You could write a PL/SQL stored subprogram to SELECT sid, serial# FROM
V$SESSION for all logged on users besides SYS (who's doing the killing),
then execute a dynamic SQL statement ALTER SYSTEM KILL SESSION for each
sid, serial# found.
Give me a day and I'll write it and post it here, since it's something
folks could use.
--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
jkwallace_at_my-dejanews.com wrote in article
<6psmb6$ik5$1_at_nnrp1.dejanews.com>...
> We do a cold backup on Tuesday nights. unfortunately, users refuse to
exit
> before shutdown and we end up doing shutdown abort, startup, shutdown
> immediate. I am afraid that someday the startup won't.
>
> Is there a script I could use to kill all users (figuratively speaking,
of
> course) before the shutdown immediate. Thanks for any and all assistance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Aug 05 1998 - 22:41:23 CDT