Re: Shutdown Normal vs Shutdown Transactional

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

I don't know. I rarely use anything else but SHUTDOWN IMMEDIATE. That rolls all the running transactions back and brings down the database. As a DBA, I usually have a fixed time slot for maintenance. When I need to shut the database down, I do it immediately. I love the smell of napalm in the morning.