Re: alter system v shutdown abort

Ruth,

Does that SA bounce a server just because one user is having a problem? If so, then steer way clear of that idiot.

You can't beat killing the process, then, if the Oracle session still exists, kill it. Always works for me and lets everyone else continue to work in the database. Sometimes killing the Oracle session first eliminates your ability to note the OS PID, which may hang around even after the Oracle session is killed. Kill the OS session first.

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

 I feel so unnecessary. -- Rufus Thomas

               ( "Do the Funky Chicken")

"Queen Roo Roo" <ruth.gramolini_at_gmail.com> Sent by: oracle-l-bounce_at_freelists.org
09/13/2006 01:41 PM
Please respond to
ruth.gramolini_at_gmail.com

To
oracle-l <oracle-l_at_freelists.org>
cc

Subject
alter system v shutdown abort

Hello everyone,
Can someone tell me an alter system kill session 'sid,serial#'; will kill runaway processes or long running queries as efficiently as doing a shutdown abort, startup , shutdown immediate? I have always run a job which shutdown kills all users who shouldn't be on after a specific time but the
SA at my new job is skepticle because another DBA told him to use a shutdown abort, startup, shutdown immediate sequence.  

Thanks in advance,
Ruth

-- 
Ruth Gramolini
ruth.gramolini_at_gmail.com 

--
http://www.freelists.org/webpage/oracle-l