Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to monitor Oracle 9i user response times?

Re: How to monitor Oracle 9i user response times?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 01 Feb 2007 17:08:25 -0500
Message-ID: <ej04s2haa0m2htn5ro4ffogjvi3mpludsn@4ax.com>


On 1 Feb 2007 03:25:55 -0800, "Ana Ribeiro" <ana.ribeiro_at_reflective.com> wrote:

>On 1 Feb, 09:12, NetComrade <netcomradeNS..._at_bookexchange.net> wrote:
>> On 25 Jan 2007 04:47:36 -0800, "Ana Ribeiro"
>>
>> <ana.ribe..._at_reflective.com> wrote:
>> >Hi all,
>> >What is the best way to monitor the Oracle user response times in an
>> >Oracle 9i database?
>>
>> >There are several VIEWS in Oracle 10g (sys.v_$sysmetric,
>> >sys.v_$sysmetric_history,sys.v_$sysmetric_summary, etc...) that make
>> >this task very easy in Oracle 10g.
>>
>> >Does anyone know what can be done in Oracle 9i to get the same kind of
>> >information?
>>
>> User response time should be tracked in application.
>> .......
>> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
>> remove NSPAM to email
>
>Thanks for your answer - I understand that Oracle 9i does not have
>resources to track this ...

You can certainly come up with something on db side (and some tools show 'average db response time').

But what if your application does the following:

for i between 1 and 1000 do
select * from my_table where id=:i;
end loop;

and another app

select * from my_table where rownum<1000;

And each query takes roughly 100ms, including network latency.

Your first request would take 1000*100ms=100sec almost 3min You second request would take a sec or two depending on your array size.

In both cases the db response time is going to stay about the same. In the first case the app is crap, and only the app (or users) would tell you that it's broken.

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Feb 01 2007 - 16:08:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US