| 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
Michael,
is this something you can run as a SAP foreground process ? If so, you can lock a specific SAP process for exclusive use by your session; this way you can know beforehand which Oracle session you need to turn 10046 tracing on for without having to guess and without losing time at the beginning of the run.
If it's purely background, you can try to limit the number of possible SAP processes by working with job classes.
mvg/regards
Jo
"Vergara, Michael (TEM)" <mvergara_at_guidant.com>
Sent by: oracle-l-bounce_at_freelists.org
02/19/2004 19:31
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: RE: Ora 9.2/HPUX 11i/Performance
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
 |
 |