RE: Wait Stats

  • From: "syed jaffar hussain" <sjaffarhussain@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 26 Apr 2004 17:10:19 +0300

Arghadeep,

I recommend you to visit ubtools.com, oraperf.com or hotsos.com where
you can upload your trace file and find the bottleneck clearly.

Best Regards,

Syed Jaffar Hussain
Sr Oracle DBA
Sejel Technology Ltd.
+966 2 6064971 x 324 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arghadeep Chatterjee
Sent: Monday, April 26, 2004 5:00 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: subratabose@xxxxxxxxxxx
Subject: Wait Stats 


I am trying to analyze a Oracle Perf problem for a client
all my low level 10046 trace shows predominantly SQL*Message to client
and from client waits ,I am of the opinion that Network is to be blamed
here Can anybody Plz take a look at one of the trace files and confirm
my findings.
Regards
Arghadeep Chatterjee
DBA "KSPL"
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: