RE: Estimating User Load on the system

I'll add my favourite - and currently overlooked - point. Network. Not the entire network as a whole, but specific server things like NIC performance, protocol stack performance, MTU (see recent excellent post by Matt on jumbo frames), and all that jazz.

my 2¢

Ciao
Fuzzy
;-)

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
> DENNIS WILLIAMS
> Sent: Monday, July 14, 2003 17:49
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Estimating User Load on the system
>
>
> 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.
> dwilliams_at_lifetouch.com
>
> -----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: jkstill_at_cybcon.com
>
> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> 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: 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
Received on Mon Jul 14 2003 - 11:18:22 CDT