It's probably doing a large amount of rollback, as stated before... if you
can't spent so much time waiting for the instance to shutdown, log on as
sysdba, issue 'shutdown abort', then issue 'startup'... Then, rollback
will be done on an 'as needed' basis... However, you your intention is
doing a cold backup you will have to wait till all dead transaction are
rolled back...

HTH,

Juliano Freitas


> it's possible, that the hanging session takes a long time rollback.
>
> hth
> Rüdiger J. Schulz
> sosys-berlin.de
>
> jayeshrshah schrieb:
>
>>Dear Guru
>>
>>when i gave command "sql>shutdown immediate" the session has been in
>> hang
>>& not going proper.
>>
>>So i can not take cold backup
>>
>>Please reply soon why it happend?
>>
>>Thanks in advance
>>regards,
>>
>>Jayesh shah
>>
>>
>>
>>
>>
>>--------
>>website: http://www.LazyDBA.com
>>Please don't reply to RTFM questions
>>Oracle documentation is here: http://tahiti.oracle.com
>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>To subscribe: see http://www.lazydba.com
>>By using this list you agree to these
>> terms:http://www.lazydba.com/legal.html
>>
>>
>>
>>
>>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>



Oracle LazyDBA home page