I was reading about the "tcp.nodelay=yes" parameter (in sqlnet.ora) for TCP/IP timeouts. How do you use the snoop utility in Solaris (or any other) to measure the performance before and after implementing the parameter? Is there anyway to see whether TCP/IP is timing out? Please advise. The nodelay turns off the nagle algorithm (queuing of messages to fill packets); I'm not sure how it would affect timeouts. tcp.nodelay is not a performance feature. It alters the way packets are delivered on the network, thereby possibly affecting performance. It is recommended to not alter this parameter unless it is known what the outcome will be. Under certain conditions for some applications using TCP/IP, Oracle Net packets may not get flushed immediately to the network. Most often, this behavior occurs when large amounts of data are streamed. The implementation of TCP/IP itself is the reason for the lack of flushing, causing unacceptable delays. To remedy this problem, specify no delays in the buffer flushing process. This is not a SQL*Net feature, but rather the ability to set the persistent buffering flag at the TCP layer. tcp.nodelay activates and deactivates Nagle's Algorithm. More information on Nagle's Algorithm can be found in RFC 896.
Dig Deeper on Oracle database design and architecture
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...
I'm having a problem with dynamic SQL, specifically getting my incoming
parameter into the SQL statement. I am using Oracle 9i and this
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.