Database Tuning (MOSC)

MOSC Banner

High CPU usage

edited Mar 22, 2010 10:14AM in Database Tuning (MOSC) 20 commentsAnswered
  body,html { background:transparent; margin: 0;}body{ top:0px; left:0px; right:0px; font:400 13px Myriad, Arial, Helvetica, clean, sans-serif; padding: 5px; background-color: white; min-height:1em; line-height:1.0}p{ margin: 1em 0; }li > ul:-moz-first-node, li > ol:-moz-first-node{ padding-top: 1.2em; } li{ min-height:1.2em; }.dijitEditorXml { color:#5a038c; font-weight:bold;} body { padding-bottom: 5px; } Hello Team,

I am running a load test in a 2 tier environment on a home grown j2ee application.

Red Hat 4.8 --> DB (10.2.0.4.3) / OAS - (10.1.3.5.0).

Application performs 3,613 SELECT and 217 DML / hour.  After 4 hours, load comes down to 1,000 SELECT and 60 DML / hour and CPU on db server spikes to 95-98%.

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