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.
[EMAIL PROTECTED]
-----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
______________________________________________________
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!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
