Re: detect shutdown normal status

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Fri, 26 Nov 1999 14:22:05 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF5D508@THOTH>

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