Bug 5057695: Shutdown Immediate Very Slow To Close Database (Doc ID 428688.1)

Last updated on DECEMBER 06, 2016

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.
***Checked for relevance on 11-Jul-2016***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms