2 Replies Latest reply: Feb 20, 2013 2:23 AM by Shivendu-Oracle RSS

    pipe get & SQL*NET message waits

    Shivendu-Oracle
      EVENT COUNT(*)
      ---------------------------------------------------------------- ----------
      SQL*Net message to client 1
      SQL*Net more data from client 1
      pmon timer 1
      smon timer 1
      wakeup time manager 1
      db file scattered read 4
      queue messages 9
      rdbms ipc message 11
      pipe get                                                                12
      db file sequential read 21
      buffer busy waits 34
      latch free 70
      SQLNet message from client 703*

      we are observing great a SQL*Net message from client and pipe get waits... can any one advice how can we reduce it

      db :9.2.0.8.0
      apps server