Re: Shutdown Normal vs Shutdown Transactional

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