Re: Oracle hangs while shutdown immediate

Anton Dischner wrote:

> Hi,
>
> Daniel, i forgot to say:
>
> We shut down all our programs which do mostly inserts and short queries.
> Only emergengy laboratory is working at his time and they are aware of
> the switch.
> There is no activity for plenty of time (approx. 1 hour) til the
> DBA is called.
> The system is complete idle at this time.
>
> Vitaly:
>
> How do you do the 'dump state of all sessions' ?
>
> Regards,
>
> Toni

If you can verify that there are no connected users and no jobs running internally such as those kicked off by DBMS_JOB then I'd go with Connor's suggestion.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)