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
[EMAIL PROTECTED] 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.
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
