Shutdown takes 5 sec per sessions via TNS listener on 12.2 and later
(Doc ID 2497007.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)
When shutdown a database instance, it takes long periods if there are many user-sessions via TNS Listener.
During shutdown, 5 seconds per an user session are needed. Also, when this is caused, a trace files is created which includes bellow information.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document