How to detect Oracle db is in process of shutting down

[Arturo Galbiati]

hi,
I suggest:
alter system checkpoint
shutdown abort
startup restrict
shutdown immediate

In this way you will baort all teh sessions connected but making a sutdown immediate as wel you will clean all the momeries, falf, etc.

Of course you must ahve a user with restricted session privilege to perform this.

HTH,
Art

[Nguyen Anh Tien]

check by issuing command:
#ps -ef|grep ora
HTH
tienna

[Frank de Vries]

Thanks for input,
it helped me to build the complete picture,
and not to overlook the obvious.