Re: tuning question when you have a 3GL application

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.
>

Try peep.sql on the Oriole site (free scripts), may point to some interesting queries.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).