Hi All,
My database is 10.2.0.4 running on windows 2008 EE (with all sevice packs). On the same box I have several workers (implemented as windows service) written in c#.net using latest ODP.NET drivers.
To improve performance I'm using ICP connection so that TCP stack (that is used in 'regular' sqlnet connections) is bypassed. I confirmed ICP is actually in use:
h4. listener log
13-NOV-2009 03:01:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
13-NOV-2009 03:01:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SID=orclwin)(CID=(PROGRAM=C:\Simulation\Agent.exe)(HOST=WIN2008EE)(USER=LOCAL?SERVICE))) * (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)) * establish * orclwin * 0
However, when I look at awr report I see sqlnet waits on top:
h4. awr top waits
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
SQL*Net message to client 3,014,783 5,086,969 1687 ###### Network
SQL*Net more data to client 1,712,644 2,441,249 1425 ###### Network
log file sync 695,446 75,297 108 ###### Commit
log file parallel write 679,437 33,288 49 916.9 System I/O
db file parallel write 49,057 22,149 452 610.1 System I/O
I have read Taner Poder's blog entry [http://blog.tanelpoder.com/2008/02/07/sqlnet-message-to-client-wait-gotcha/] concerning
SQNet message to client
and his further comments about
SQLNet more data to client [http://blog.tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/]
to get the deeper understanding of them.
The question is why do I observe SQLNet connection specific waits when using IPC connections ?
I'll appreciate any comments.
Thanks,
Rafal.