Re: Waits on pipe get ?

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 8 Dec 2000 14:43:51 +0530
Message-Id: <10704.123985@fatcity.com>

Hi !

I think it is an idle wait event (waiting for work- bench peroid :)) and can be ignored simply.

Warm Regards,
K Gopalakrishnan,
Bangalore, INDIA

• Original Message ----- From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, December 08, 2000 8:55 AM Subject: Waits on pipe get ?

>
> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infy.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

---

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. Received on Fri Dec 08 2000 - 03:13:51 CST