This is our old Q&A Site. Please post any new questions and answers at

background: I am troubleshooting a intermittent performance problem we have with a Windows 7 client connecting to oracle 10g database running on a linux 2.4.x server. [ note: i do not have access to the server ]. the app runs once a day as a scheduled task on windows 7. it makes numerous queries to the database and all the queries complete within 1 minute. the longest query is always the first one and that normally it takes 1-2 seconds.

this will happen for several days. then for a few days the first query will take 9.7 minutes to return the results, all other queries return quickly. then it will return to normal.

as part of that troubleshooting i noticed:

  1. the following options were supported by the server during the handshake for the slow query: MSS, SACK, and WS (128)
  2. the following options were supported by the server during the handshake for the fast query: MSS.

What would cause a server to support SACK for some connections and not support it at another time for the same client. In both cases the options supported by the client were the same.

asked 24 Jan '15, 23:22

Mark%20Nassy's gravatar image

Mark Nassy
accept rate: 0%

closed 26 Jan '15, 05:44

Jaap's gravatar image

Jaap ♦

The question has been closed for the following reason "Question is off-topic or not relevant" by Jaap 26 Jan '15, 05:44

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 24 Jan '15, 23:22

question was seen: 2,225 times

last updated: 26 Jan '15, 05:44

p​o​w​e​r​e​d by O​S​Q​A