Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle server max response SQL statements

Status
Not open for further replies.

NetTech123

IS-IT--Management
Dec 4, 2007
1
US
Greetings,

My company uses Sniffer portable for packet captures, and I'm troubleshooting an application that talks TNS between app/database.

My question is what are the exact metrics sniffer is using to calculate the SQL max response times?

Multiple packet captures confirm that the SQL max response times are minimal during normal operation however when users begin reporting slowness is coincides with substantial increases in these SQL response time statements in sniffer.

Our database folks are saying their servers are processing the requests in a timely manner even during slowness issues stating the way the application accesses the DB servers may be an issue. They said it works similar to Kronos in so far as it accesses the DB servers.
 
Hi,
the best way is to identify a TNS/SQL/Slow Database symptom / diagnosis in one of your trace files. Drill into the detail and filter out the TCP connection using the wizzard stick.
Alt F3 and then find the specific diagnosis in the trace detail / decode window.
You will clearly see the delay in the delta time column.
ou can see the difference in transport delay (TCP delay) and database delay.
You will see the database request from the client and if the database is quick the database response will be immediate.
If the database / server is slow you will see the request from the client, and ACK from the server and then later you will see the databse response with the TCP Push bit set.
The time from the initial request till the Ack is the network delay.
The time from the initial request (or even the time from the ack) till the database response is the database delay.
Mark the Ack packet - the Relative Time column from the Ack packet till the database response will be your database response time.

So to answer your question, it is not a metrix that sniffer use, it is an actual measurement from when the request was sent till the reply was received.
You can see the difference in summary in the Connection / Detail - view the Avg Ack time compared to the Max App Response
Hope it helps ...
Reon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top