Check if there are some cache buffer chains contention through v$session_wait and v$latchname. Maybe some sqls have changed their plans. Because of index dropped or change of code.
Regards. --- Uma Mohoni <[EMAIL PROTECTED]> wrote: > Yeah there was a sudden burst of activity in data > insert, updates and > deletes over the weekend as a result of a new app > module being tested. But > the client app uses Java code and is not in the > database. So its nothing I > can ask them to remove. On the other hand sudden > bursts of data activity is > something that might very well happen in the normal > course of the > application so I guess I need to be prepared for > it..Thanks, for the > suggestion. > -Uma > > -----Original Message----- > Sent: Tuesday, January 22, 2002 11:31 AM > To: Multiple recipients of list ORACLE-L > > > Has there been any changes in the applications? I > had someone put in new > code this weekend and it sent my CPU up over 80%. > When I saw that Monday > morning, I had the developer take the code out and > my CPU dropped back down > to around the 5 - 10%. From my little experience I > have quickly learned > that when you see something like your CPU go up, > check what modifications to > applications have occurred. > > Dave > > -----Original Message----- > Sent: Tuesday, January 22, 2002 9:20 AM > To: Multiple recipients of list ORACLE-L > > > Hi, > I would like help with this problem I am grappling > with since yesterday. One > of the test boxes with Sun Solaris 2.7 OS and Oracle > 8.1.7.2 on it has > started showing 97% and above CPU usage mostly by > Oracle . It has slowed > down the application to a point where the testers > can not test. Does any one > have any idea why Oracle would suddenly hog CPU so > much? The normal CPU > usage on these boxes is 2%-3%. All help is greatly > appreciated. Thanks in > advance. > > Thanks, > Uma Mohoni > Consultant, CDI Corporation > @ iKimbo Inc. > 500-A Huntmar Park Drive > Herndon, VA 20170 > (703) 904-4150 Ext:237 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Uma Mohoni > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Uma Mohoni > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
