RE: How to calculate user load on the system

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:Rajendra.Jamadagni_at_espn.com]

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! Received on Wed Jan 16 2002 - 17:24:53 CST