Re: Shutdown Normal vs Shutdown Transactional

Shutdown immediate is the default for me, if I need to shutdown I need to shutdown fast.

Shutdown abort is usually faster overall, annd instance recovery isn’t that scary in modern versions.

Thanks,
Andy

On Thu, 5 Sep 2024 at 4:11 AM, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com> wrote:

> Maybe because things are clear for normal, as you have to wait up to last
> disconnect, but for transactional mode people can get fooled by the fact
> that transactions are sort and the shutdown should happen fast, which can
> be false for some scenarios, so I will take it like a heads up message
>
> On Thu, Sep 5, 2024, 9:37 AM Hameed Amir <dmarc-noreply_at_freelists.org>
> wrote:
>
>> 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-l