Re: tuning question when you have a 3GL application

Just wondering if the Software Engineering Team can be taught how to run their own 10046 trace (capturing the painful "part" of their application). The Hotsos Sparky tool (free) can help the 10046 tracing, including the automation of sending the trace file to the team for analysis.

<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 :)

rgaffuri_at_cox.net 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 <jkstill_at_cybcon.com>
>>Date: 2003/08/19 Tue AM 10:34:24 EDT
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>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, rgaffuri_at_cox.net 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: <rgaffuri_at_cox.net
>>> INET: rgaffuri_at_cox.net
>>>
>>>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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com
>>
>>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: ListGuru_at_fatcity.com (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: ocp-dba_at_earthlink.net

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: ListGuru_at_fatcity.com (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).