Database Tuning (MOSC)

MOSC Banner

CPU Utilization very high at the time of Logical Backup EXPDP

edited Sep 27, 2012 10:53AM in Database Tuning (MOSC) 5 commentsAnswered
Dear All,

      CPU Utilization very high at the time of Logical Backup EXPDP only .Please find the details below and suggest the resolution asap.

Details:

System: npsdbpr Tue Sep 25 22:00:05 2012
Load averages: 0.28, 0.08, 0.05
503 processes: 433 sleeping, 70 running
Cpu states:
CPU   LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 0    0.28  83.8%   0.0%   6.4%   9.8%   0.0%   0.0%   0.0%   0.0%
 2    0.32  84.2%   0.0%   7.8%   8.0%   0.0%   0.0%   0.0%   0.0%
 4    0.25  82.0%   0.0%   8.8%   9.2%   0.0%   0.0%   0.0%   0.0%
 6    0.27  84.4%   0.0%   8.2%   7.4%   0.0%   0.0%   0.0%   0.0%
---   ----  -----  -----  -----  -----  -----  -----  -----  -----
avg   0.28  83.8%   0.0%   7.8%   8.4%   0.0%   0.0%   0.0%   0.0%

System Page Size: 4Kbytes
Memory: 7600412K (3037172K) real, 10969892K (4347560K) virtual, 4267780K free  Page# 1/72

Generated time 22:00
System: npsdbpr Mon Sep 24 22:00:05 2012
Load averages: 0.30, 0.08, 0.05
502 processes: 434 sleeping, 68 running
Cpu states:
CPU   LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 0    0.28  90.8%   0.0%   8.6%   0.6%   0.0%   0.0%   0.0%   0.0%
 2    0.27  87.2%   0.0%  12.6%   0.2%   0.0%   0.0%   0.0%   0.0%
 4    0.30  91.8%   0.0%   7.4%   0.8%   0.0%   0.0%   0.0%   0.0%
 6    0.33  91.0%   0.0%   8.2%   0.8%   0.0%   0.0%   0.0%   0.0%
---   ----  -----  -----  -----  -----  -----  -----  -----  -----

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center