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 [EMAIL PROTECTED] -----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: [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).
