Re: statspack comment is needed

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 7 Dec 2006 22:53:00 -0800
Message-ID: <1165560780.012319.270750@n67g2000cwd.googlegroups.com>

Hi ,

Thank you very much for your help.

Based on the article ,

the system has 8 cpus .
5551 secs ( 92) min cpu time in 60 minutes : if i have 2 cpus utilized 100 % then , i can get 120 min. cpu time , here only 92 min. cpu time can be achieved by using only 2 cpus, i have 8 , so only %20 of total cpu resources is used.

Is it correct?

The application is an oltp which has strict transaction limitations such as every business procedure has 4 secs. time out value.

This is another part of the report , which shows high numbers of av rd(ms)

Tablespace Filename

---

---

                 Av      Av     Av                    Av        Buffer
Av Buf
         Reads Reads/s Rd(ms) Blks/Rd       Writes Writes/s      Waits

Wt(ms)
-------------- ------- ------ ------- ------------ -------- ----------

---

UNDO_TBS_FIRST                 /dev/vx/rdsk/datadg/UNDOFIRST
             1       0  110.0     1.0        1,021        0          3
  0.0
                         /dev/vx/rdsk/datadg/verde_raw_undo12_8g
             1       0   90.0     1.0        2,555        1         17
  0.0
                         /dev/vx/rdsk/datadg/verde_raw_undo1_1g
             1       0   90.0     1.0          850        0          6

  1.7

UNDO_TBS_SECOND                 /dev/vx/rdsk/datadg/UNDOSECOND
             1       0   90.0     1.0            1        0          0
                         /dev/vx/rdsk/datadg/verde_raw_undo22_1g
             1       0  120.0     1.0            1        0          2
  0.0
                         /dev/vx/rdsk/datadg/verde_raw_undo2_1g
             1       0   90.0     1.0            1        0          0

Kind Regards,
hope

joel garry wrote:
> hopehope_123 wrote:
> > Hi Gurus ,
> >
> >
> > Snap Id Snap Time Sessions Curs/Sess Comment
> > --------- ------------------ -------- ---------
> > -------------------
> > Begin Snap: 2428 07-Dec-06 16:10:00 96 12.2
> > End Snap: 2429 07-Dec-06 17:10:00 167 14.4
> > Elapsed: 60.00 (mins)
> >
> >
> > Top 5 Timed Events
> > ~~~~~~~~~~~~~~~~~~
> > % Total
> > Event Waits Time (s)
> > Ela Time
> > -------------------------------------------- ------------ -----------
> > --------
> > CPU time 5,551
> > 69.62
> > db file sequential read 37,573 689
> > 8.65
> > log file parallel write 76,392 406
> > 5.10
> > log file sync 19,417 377
> > 4.72
> > db file scattered read 16,016 239
> > 2.99
> >
> >
> > This is a 60min. interval output of statspack. It says 5551 second is
> > spent on cpu. 5551 sec. is greater than 60min. What does this value
> > mean? How can i comment about ?Is it worth the effort to deal with the
> > cpu time ?

>

> see http://www.jlcomp.demon.co.uk/statspack_01.html

>

> jg
> --
> @home.com is bogus.
> Put the CFO in charge and tell people you are continuing to hire great
> people. Riiiiight.
> http://www.signonsandiego.com/uniontrib/20061207/news_1b7yahoo.html
Received on Fri Dec 08 2006 - 00:53:00 CST