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 <umohoni_at_ikimbo.com> 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
> umohoni_at_ikimbo.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Uma Mohoni
> INET: umohoni_at_ikimbo.com
>
> 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: ListGuru_at_fatcity.com (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: DFarnsworth_at_Ashleyfurniture.com
>
> 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: ListGuru_at_fatcity.com (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: umohoni_at_ikimbo.com
>
> 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: ListGuru_at_fatcity.com (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
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
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: ctrassens_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Jan 22 2002 - 12:59:02 CST
