Bug 5057695: Shutdown Immediate Very Slow To Close Database
(Doc ID 428688.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.3 [Release 9.2 to 10.2]Information in this document applies to any platform.
Symptoms
Recently upgraded the database to a version between 9.2.0.7 to 10.2.0.3.
A database with 150 or more connections takes a very long time to shutdown, compared to the same system when using Oracle 9i (9.2.0.6 and prior) where shutdown was very fast.
Given the fact there is no activity on the connections in question, rollbacks aren't an issue.
There are no trace files and no indication of a problem in the alert log.
Changes
Recently upgraded the database to a version between 9.2.0.7 to 10.2.0.3
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |