Re: Oracle Hung during Shutdown

In article <449ule$gif_at_theopolis.orl.mmc.com> troyt_at_csdc02.orl.mmc.com (troy trimble) writes:
> In article ecj_at_tcsi.tcs.com, Sundar Raghavan <sundar_at_tcs.com> writes:
> >This happened a few times at our site. The "reason" seems to be
> >user connections that are alive even after a DBA/Sys Admin threat
> >to shutdown the machine. If you come across any other reason,
> >please post it to the group.
>
> If you do a normal shutdown, it will wait for clients to exit before
> shutting down the database. If you perform an immediate shutdown
> (use only if necessary) will immediately disconnect all clients and
> shut down the database.

I disagree with the last sentence. While it is true that an immediate shutdown immediately terminates all connections, all pending, uncommitted transactions are rollbacked before the database is closed and dismounted. So from a DBA point of view, it is very safe and efficient. Of course end users may not like it.

--
 "Everything that can be said about Win95 has been said... The Win95 user
  interface is not nearly as good as the Mac.  Blah, blah.  It has all been
  said a thousand times." - Larry Ellison

 Alvin W. Law ........................................... Oracle Corporation
 Senior Technical Consultant ................ 300 Oracle Parkway, Box 659305
 Applications Design & Architecture ............... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ...... Voice: +1.415.506.8317 . Fax: +1.415.506.7294