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
[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).
begin:vcard
n:Fink;Daniel
x-mozilla-html:FALSE
org:Sun Microsystems, Inc.
adr:;;;;;;
version:2.1
title:Lead, Database Services
x-mozilla-cpt:;9168
fn:Daniel W. Fink
end:vcard
