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?

Many thanks in advance,
Ana

On 25 Jan 2007 04:47:36 -0800, "Ana Ribeiro"
<ana.ribeiro@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

On 1 Feb, 09:12, NetComrade <netcomradeNS...@bookexchange.net> wrote:
> On 25 Jan 2007 04:47:36 -0800, "Ana Ribeiro"
>
> <ana.ribe...@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 ...
Kind regards,
Ana

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

>On 1 Feb, 09:12, NetComrade <netcomradeNS...@bookexchange.net> wrote:
>> On 25 Jan 2007 04:47:36 -0800, "Ana Ribeiro"
>>
>> <ana.ribe...@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

>Your first request would take 1000*100ms=100sec almost 3min
that should've said almost 2min

........
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
remove NSPAM to email