Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Statspack Report!

Statspack Report!

From: Gunnar Berglund <oracledbasweden_at_yahoo.co.uk>
Date: Mon, 29 Sep 2003 20:29:39 -0800
Message-ID: <F001.005D1677.20030929202939@fatcity.com>


Hi all,  

could you please clarify me what these might mean (and how to tune the db in order to avoid those).  

So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand:  

Child          Get                           Spin &
Latch Name                 Num     Requests      Misses     Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains       609      750,125         572         58 0/0/0/0/0
cache buffers chains       610      641,794         673         38 0/0/0/0/0
cache buffers chains       611      508,147         246         23 0/0/0/0/0
cache buffers chains       608      374,928          96         11 0/0/0/0/0

and  

Top 5 Timed Events

~~~~~~~~~~~~~~~~~~                                                     % Total
Event                                               Waits    Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
direct path write (lob)                           101,116      13,637    38.23
 

and  

Event                               Waits   Timeouts   Time (s)   (ms)     /txn
---------------------------- ------------ ---------- ---------- ------ --------
rdbms ipc message                 218,281    202,375    809,339   3708      0.8

Sorry for the mess, but please try to read...  

TIA
gb



Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: =?iso-8859-1?q?Gunnar=20Berglund?=   INET: oracledbasweden_at_yahoo.co.uk
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). Received on Mon Sep 29 2003 - 23:29:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US