<plug> The Hotsos profiler is ideal for analyzing the trace file. </plug>
The free trace analysis tools: tkprof and Oracle Trace Analyzer have some shortcomings.
Have Fun :)
[EMAIL PROTECTED] wrote:
its the way the taem is organized. all communication goes through the product managers to the client. No direct access for the technical people.
i dont make the rules. I just have to live with them. Ive been onsite with clients before. its easier.
So Im looking for things to make my life easier... :( luckily yesterday was a problem with the COM objects and had nothing to do with the database.
From: Jared Still <[EMAIL PROTECTED]> Date: 2003/08/19 Tue AM 10:34:24 EDT To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: tuning question when you have a 3GL application
Your customer tells you that the database is slow, but won't allow you the opportunity to correct it if that is the case?
As Cary says, your problem is not a technical one. It sounds as if they don't *want* you to have the opportunity to prove that the database is not the problem.
Jared
On Mon, 2003-08-18 at 12:24, [EMAIL PROTECTED] wrote:
We have two teams. Database team and a Software engineering team. The software engineering team wrote an application in .net.
We periodically get 'the application is slow' from them. I have not gotten the ok to run statspack in production.
Are there any canned scripts I can run to monitor the v$views or latch contention etc... It may not be the database, but I need some metrics.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).