Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: > I have been asked to compute the load put on the system by a 'select group > of userids'. I know these users and have put something in place where I > sample periodically following > > 1. session stats > 2. session io > 3. system stats > 4. number of sessions > 5. v$transaction > > Am I missing something? Has anyone done this before? If so, what have you > computed ? > > TIA > Raj > --------------------------------------------------------------------------- >- ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).