Raj, sorry for me being confused. Are you trying to measure what the application executable is doing outside the database (i.e.. host system load) or the activity inside the database (i.e.. per user/program/module DB stats)?
Tony
-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 4:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: How to calculate user load on the system
Dennis,
Actually we have N users on the system where N is a variable. Of that I have
a certain group of users, I need to monitor and see how much load they put
on the system.
The idea is out on N total users on the system, X number of users use only
one part of application 95% of the time (because it is their job). So, If I
get some kind of metric (numbers ... numbers) then we might think of
spinning these users and their application to another box in their own
instance. They can talk to our application by db links, so that won't be a
problem.
I am looking for some kind of metric to either prove the need for another
box and instance or otherwise.
Hopefully this time it is little bit clear ...
TIA
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
