Re: Performance Issue on 817 !!!

>Hi guys
>
>Compliments of the new season.
>
>We have a database running on Oracle 817 and there are around 4 to 5
>applications running there. Initially the platform was Windows NT,
>service pack 6. Everything was working fine, now recently, the O/S was
>upgraded to Windows 2000. Then our problems started, one of those 4 to
>5 applications is having a severe performance problems, others are
>working fine. Now the problem is that one does not know if the O/S
>upgrade have an effect on this, or maybe that particular application
>is having the problems. Help advice as now things are sour. What could
>have been the main problem, on the Database, Application or Operating
>system level ? I thought it could not be the database because other
>applications are working fine on the very same database, I could be
>wrong .... Please help .....1
>

Jackson,

   First thing to do is to qualify your 'performance problem'. Usually in IT it gets down to CPU, I/Os or network. If everything is fine then it may be lock or latch related, and the suitable V$ views should help you check this. Check V$WAITSTAT, V$SYSTEM_EVENT, V$SQL (queries most heavy on buffer gets) and try to narrow the scope of your problem.

HTH Stephane Faroult

--
Diese E-Mail wurde mit http://www.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net
Der Absender dieser E-Mail hatte die IP: 195.115.41.103

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).