DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Pipe get Event

  1. #1
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109

    Pipe get Event

    HI,

    Can anyone tell me is there is any problem in my database due to this pipe get event?

    select s.sid,s.username,sw.event,sw.state,sw.seconds_in_wait
    2 from v$session s,v$session_wait sw
    3 where s.username is not null
    4 and s.sid=sw.sid
    5 and sw.event not like '%SQL*Net%'
    6 ;

    SID USERNAME EVENT STATE SECONDS_IN_WAIT
    ---------- ------------------------------ ---------------------------------------------------------------- ------------------- ---------------
    18 APP pipe get WAITING 21
    52 APP pipe get WAITING 38
    54 APP pipe get WAITING 59
    58 APP pipe get WAITING 21
    119 APP pipe get WAITING 5
    120 APP pipe get WAITING 7


    The above query shows pipe get event is waiting for 21,38,59,21,5 and 7 seconds. Is this event cause any performance problem?

    My current CPU Utilization is 100.

    Seelan

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Pipe get is a idle wait event and can be ignored

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width