| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to calculate user load on the system
Raj - I don't know DGUX, but if the users each have their own system login,
the system administrator may be able to help. With forms, that may not help.
>From my experience, there isn't any ready way within Oracle.
Another idea might be to sample the system load and number of users for each group from time to time and try to correlate system load by group. I've never tried that, though.
If you have a test system, you could have group 1 run some representative work and measure the system load, then have group 2 run some representative work. That might give you a closer idea.
Another thought. DB links can produce inefficient results. Are you
sure that moving them to another system won't produce worse results?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, January 16, 2002 3:31 PM
To: Multiple recipients of list ORACLE-L
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
QOTD: Any clod can have facts, but having an opinion is an art!
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jan 16 2002 - 16:40:11 CST
 |
 |