High CPU Usage and High Redolog Generation from SMON Process (Doc ID 1569564.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Sep-2016***

Symptoms

- High cpu usage and high redolog generation reported by smon.

- Shutdown immediate hangs

- ASH report contains:

Top Sessions

  Sid, Serial# % Activity Event % Event
--------------- ---------- ------------------------------ ----------
User Program # Samples Active XIDs
-------------------- ------------------------------ ------------------ --------
  219, 1 64.52 CPU + Wait for CPU 64.52
SYS oracle@orarh64....co.nz (SMON) 3,610/3,615 [100%] 0

  192,28348 1.64 CPU + Wait for CPU 1.52
ECLAIR w3wp.exe 85/3,615 [ 2%] 40

  177,43680 1.59 CPU + Wait for CPU 1.54
ECLAIR w3wp.exe 86/3,615 [ 2%] 44

  221, 1 1.09 log file parallel write 1.04
SYS oracle@orarh64....co.nz (LGWR) 58/3,615 [ 2%] 0

  88,29672 1.00 db file sequential read 0.61
ECLAIR w3wp.exe 34/3,615 [ 1%] 0

  -------------------------------------------------------------

 
- Alert log shows high redolog:

Fri Jul 05 08:19:56 NZST 2013
Thread 1 advanced to log sequence 378574 (LGWR switch)
  Current log# 2 seq# 378574 mem# 0: /dbonlog/ECLR/log2ECLR.dbf
Fri Jul 05 08:23:21 NZST 2013
Thread 1 advanced to log sequence 378575 (LGWR switch)
  Current log# 1 seq# 378575 mem# 0: /dbonlog/ECLR/log1ECLR.dbf
Fri Jul 05 08:26:47 NZST 2013
Thread 1 advanced to log sequence 378576 (LGWR switch)
  Current log# 3 seq# 378576 mem# 0: /dbonlog/ECLR/log3ECLR.dbf
Fri Jul 05 08:29:56 NZST 2013
Thread 1 advanced to log sequence 378577 (LGWR switch)
  Current log# 2 seq# 378577 mem# 0: /dbonlog/ECLR/log2ECLR.dbf
Fri Jul 05 08:34:28 NZST 2013
Thread 1 advanced to log sequence 378578 (LGWR switch)
  Current log# 1 seq# 378578 mem# 0: /dbonlog/ECLR/log1ECLR.dbf
Fri Jul 05 08:39:51 NZST 2013
Thread 1 advanced to log sequence 378579 (LGWR switch)
  Current log# 3 seq# 378579 mem# 0: /dbonlog/ECLR/log3ECLR.dbf
Fri Jul 05 08:44:52 NZST 2013
Thread 1 advanced to log sequence 378580 (LGWR switch)
  Current log# 2 seq# 378580 mem# 0: /dbonlog/ECLR/log2ECLR.dbf
Fri Jul 05 08:48:09 NZST 2013
Thread 1 advanced to log sequence 378581 (LGWR switch)
  Current log# 1 seq# 378581 mem# 0: /dbonlog/ECLR/log1ECLR.dbf
Fri Jul 05 08:51:09 NZST 2013
Thread 1 advanced to log sequence 378582 (LGWR switch)
  Current log# 3 seq# 378582 mem# 0: /dbonlog/ECLR/log3ECLR.dbf
Fri Jul 05 08:53:31 NZST 2013
Thread 1 advanced to log sequence 378583 (LGWR switch)
  Current log# 2 seq# 378583 mem# 0: /dbonlog/ECLR/log2ECLR.dbf
Fri Jul 05 08:56:12 NZST 2013
Thread 1 advanced to log sequence 378584 (LGWR switch)
  Current log# 1 seq# 378584 mem# 0: /dbonlog/ECLR/log1ECLR.dbf
Fri Jul 05 08:58:12 NZST 2013
Thread 1 advanced to log sequence 378585 (LGWR switch)
  Current log# 3 seq# 378585 mem# 0: /dbonlog/ECLR/log3ECLR.dbf

 

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