RE: Ora 9.2/HPUX 11i/Performance
- From: "Ron Thomas" <rthomas@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Feb 2004 11:35:55 -0700
I've seen this happen before. In this case, sar and dmesg are your friends.
Make sure that you are
not getting any scsi resets due to a flaky controller or a disk that is about
to crash.
Ron Thomas
Hypercom, Inc
rthomas@xxxxxxxxxxxx
"The box said I needed to have windows 98 or better...So I installed linux."
mvergara@xxxxxxxxx
om To:
oracle-l@xxxxxxxxxxxxx
Sent by: cc:
oracle-l-bounce@fr Subject: RE: Ora 9.2/HPUX
11i/Performance
eelists.org
02/19/2004 11:31
AM
Please respond to
oracle-l
Mike:
Our ABAPers have stared at this until they're blue in the
face. The problem is that no matter what tool we've tried
so far has not shown us what the problem might be. We
have used Quest Spotlight, Statspack, Statspack Viewer,
TOAD, Oracle Enterprise Manager...no joy anywhere.
Cheers,
Mike
-----Original Message-----
From: Hand, Michael T [mailto:HANDM@xxxxxxxxxxxx]
Sent: Thursday, February 19, 2004 10:07 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Ora 9.2/HPUX 11i/Performance
Michael,
How about using the SAP user trace? Turn it on for the user running
the report and off after the report is generated. You'll have more
information than you know what to do with.
Mike Hand
-----Original Message-----
From: Vergara, Michael (TEM) [mailto:mvergara@xxxxxxxxxxx]
Subject: Ora 9.2/HPUX 11i/Performance
Hi Everyone!
We are having intermittent and irregular performance issues
with one of our home-grown reports from our SAP system. I tried
running a SQL trace, but it was insufficient to our needs.
--
This transmission is intended only for use by the addressee(s) named =
herein and may contain information that is proprietary, confidential =
and/or legally privileged. If you are not the intended recipient, you =
are hereby notified that any disclosure, copying, distribution, or use =
of the information contained herein (including any reliance thereon) is =
STRICTLY PROHIBITED. If you received this transmission in error, please =
immediately contact the sender and destroy the material in its entirety, =
whether in electronic or hard copy format. Thank you.
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
