My Oracle Support Banner

Database Appears Hanging but Generates Huge Amount of Redo and Archived Redo Logs (Doc ID 231713.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Generic UNIX

Goal

Your database is generating huge amount of redo logs with the archive processes creating new
archived logs very often (for example, the 100MB size redo logs are fullfiled and archived every
10 sec), but no one is doing anything on the database.

The queries run against the database are not completing, jobs seem to be hanging, although
simple queries against the data dictionary can be run ok.

Shutdown immediate hangs, after shutdown abort and restart in normal or restricted mode,
the situation is the same. Rebooting the box does not make any difference in what has been
observed.

The major applications can not be run and your database has not been operational possibly
for many hours already.

In the output from 'ps -ef|grep <Oracle SID>' you can see one or more processes (like
ora_p001_<SID>, ora_p002_<SID>, ...), consuming a lot of CPU time.
The CPU time consumed by SMON at the same time, however, is not that significant.

In addition, the size of the rollback segments (from RDA output or other source) have grown
to the size, which is times greater than their initial size configured (this may vary depending on
the rollback segments settings, 'optimal' in particular).

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.