Shutdown Normal vs Shutdown Transactional
From: Hameed Amir <"Hameed>
Date: Thu, 5 Sep 2024 00:36:23 +0000
Message-ID: <SN7PR14MB64703689D8AAD8BE2983AFB4E09D2_at_SN7PR14MB6470.namprd14.prod.outlook.com>
Hi folks,
Date: Thu, 5 Sep 2024 00:36:23 +0000
Message-ID: <SN7PR14MB64703689D8AAD8BE2983AFB4E09D2_at_SN7PR14MB6470.namprd14.prod.outlook.com>
Hi folks,
The 19c Concepts Manual has the following definitions of the two shutdown modes:
SHUTDOWN NORMAL - This is the default mode of shutdown. The database waits for all connected users to disconnect before shutting down.
SHUTDOWN TRANSACTIONAL - This mode prevents users from starting new transactions, but waits for all current transactions to complete before shutting down. This mode can take a significant amount of time depending on the nature of the current transactions.
From the definition, it seems that Shutdown Normal can take longer than Shutdown Transactional because in the former case, the DB waits for all users to disconnect. I wonder why the opposite is mentioned for Shutdown Transactional.
Thank you,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 05 2024 - 02:36:23 CEST