Cathy ,

You checked things like statistcis, fts etc.
If the upgrade of the application also changed some tables , check things
like
default parallel degree of the table and indexes

for example
default parallel will use the max_parallel_server value of your system.
CBO in 9/10 will try favour parallel full tablescans (not so bad) instead of
an index scan.
But this makes a lot of extra processes , the extra processes (context
switches), it
can blow your CPU sky high.

What are your top 5 wait events ?


Regards

Lars Jans






-----Original Message-----
From: chaskins
[mailto:oracledba-ezmlmshield-x45850803.[Email address protected]
Sent: donderdag 29 mei 2008 23:41
To: LazyDBA Discussion
Subject: CPU usage steady at 95 - 100 since application upgrade



Not quite sure how to handle this, but an application upgrade took place
yesterday and ever since then the Current, Average, and High CPU
Utilization is going crazy. Any ideas of how to troubleshoot this from a
DBA perspective to find out what happened? How to fix this? The vendor is
checking it out, too. This system is like this without even running any
exports and backups that kick-off tonight. I have STATSPACK's reports,
but not really that familiar with what to look for, new to reading them.

If you have any questions please let me know. Thanks

Cathy Haskins




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page