Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pipe get & SQL*NET message waits

Shivendu-OracleSep 28 2010 — edited Feb 20 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2013
Added on Sep 28 2010
2 comments
1,175 views