| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ora 9.2/HPUX 11i/Performance
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_at_hypercom.com
"The box said I needed to have windows 98 or better...So I installed linux."
mvergara_at_guidant.c
om To: oracle-l_at_freelists.org
Sent by: cc:
oracle-l-bounce_at_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_at_polaroid.com]
Sent: Thursday, February 19, 2004 10:07 AM
To: 'oracle-l_at_freelists.org'
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_at_guidant.com]
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.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |