RE: How to calculate user load on the system

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 16 Jan 2002 14:38:18 -0800
Message-ID: <F001.003F1F4E.20020116141048@fatcity.com>

Take a look at V$SYSSTAT. I'm not sure if it's the answer because your question specifies a set of users. V$SYSSTAT includes all users not just a particular set.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Wednesday, January 16, 2002 12:27 PM To: Multiple recipients of list ORACLE-L

Friends, Gurus, New-DBAs, DBA-wannabes and everyone else ...

I have been asked a simple question, and I am stumped ...

Given a set of users, how to calculate the load they are putting on the system when using our application (CPU, MEMORY etc). We have 8161 running on DGUX (yeah, I know ...) Forms application, Oracle Reports, SQR reports, sql scripts, and two traffic using db_links with couple of other databases.

Is anyone doing this? What is the best approach?

Thanks in advance for your ideas ...

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: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

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:38:18 CST