Re: tuning question when you have a 3GL application

10046, and only 10046. There are many ways to set this event, even in another session. It is the method for identifying the exact problem. Statspack and queries on v$ views have their own shortcomings that make them inefficient for use in identifying specific problems.

Get the SE team to identify what is slow, when it is slow. If they can repeat it, run a test with 10046 enabled. That WILL identify the cause of the response time degradation.

Daniel Fink

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: Daniel Fink
  INET: Daniel.Fink_at_Sun.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).



text/x-vcard attachment: Card for Daniel Fink