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

Home -> Community -> Mailing Lists -> Oracle-L -> Waits on pipe get ?

Waits on pipe get ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
Date: Thu, 7 Dec 2000 18:37:41 +0530
Message-Id: <10703.123925@fatcity.com>


What needs to be Done ?

SVRMGR> Rem System wide wait events for non-background processes (PMON,
SVRMGR> Rem SMON, etc).  Times are in hundreths of seconds.  Each one of
SVRMGR> Rem these is a context switch which costs CPU time.  By looking at
SVRMGR> Rem the Total Time you can often determine what is the bottleneck
SVRMGR> Rem that processes are waiting for.  This shows the total time spent
SVRMGR> Rem waiting for a specific event and the average time per wait on
SVRMGR> Rem that event.
SVRMGR> select 	n1.event "Event Name",
     2>        	n1.event_count "Count",
     3> 	n1.time_waited "Total Time",
     4> 	round(n1.time_waited/n1.event_count, 2) "Avg Time"
     5>    from stats$event n1
     6>    where n1.event_count > 0
     7>    order by n1.time_waited desc;
Event Name                       Count         Total Time    Avg Time
-------------------------------- ------------- ------------- -------------
SQL*Net message from client            6681872     731773979        109.52
pipe get                                596302     238963818        400.74
enqueue                                   2965        775823        261.66
db file sequential read                 402561        622338          1.55
SQL*Net more data from client            57646        362115          6.28
log file sync                            63582        342001          5.38
db file scattered read                  162432        156715           .96
SQL*Net more data to client             790766        108171           .14
log buffer space                          8997         16088          1.79
Received on Thu Dec 07 2000 - 07:07:41 CST

Original text of this message

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