Re: tuning question when you have a 3GL application

Cary is spot on. The technical problem is fairly easy to address. The political problem is the real issue. Will your manager support you in laying down the 'rules of engagement'? Do you have the ability/support to push back and say "I will be glad to help, but I need the following from the development team/testers/users. 1) Full access to the database in question. 2) Interaction with the users experiencing the problems. 3) The ability to run tests, craft proposed solutions and test them for response time quantification. Until I receive these things, I cannot help you."

Daniel
rgaffuri_at_cox.net wrote:
>
> all i usually get is 'the application is slow'
>
> i cant get more out of them than that. its in acceptance testing so i often get that from the customer. they are offsite and i dont have direct contact with them.
>
> so i cant run traces on individual sessions. Further when the database runs slow they stop what they are doing. So it makes it harder. Im not that familiar with the v$wait and v$statistics views. I was hoping there are some queries so i can gather my own stats.

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