Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: detect shutdown normal status
You could try looking at the value of shutdown_pending in V$INSTANCE as
this will give a YES or NO answer
SELECT shutdown_pending FFOM V$INSTANCE
Gary Waldrom
Amonra Insight Ltd.
Makers of Q-file IT Quick Reference Guides www.q-file.com
-----Original Message-----
From: Gombos Bertalan [mailto:bgombos_at_freemail.hu]
Posted At: 26 November 1999 10:41
Posted To: server
Conversation: detect shutdown normal status
Subject: detect shutdown normal status
Hi all,
I've a queue processing engine which runs in unlimited loop. Before
shutting down database in normal mode it's necessitous to finish this
engine
(it is clear), my question is how can I determine from my procedure
whether
shutdown is in progress?
Thanks, bye:
--
G o m b o s B e r t a l a n
system engineer, Oracle developer
mailto:bgombos_at_freemail.hu Received on Fri Nov 26 1999 - 08:22:05 CST