Strange traffic surge

N

Nastya

Member
Hello!
We've developed the following application : client (Delphi 5, DOA 3) rather frequently requests Oracle (8.1.7) server some data. The frequence is constant. When looking at the traffic report it's seems that the size on each iteration is quite normal. BUT: sometimes there's a big (about 10 Mb, while ordinal size is 300 Kb) traffic surge - client receives some big data.
We repeated all SQL queries in SQL PLUS - and got normal traffic report.
Why it happens and what can be done ?

( Client uses TOracleSession, TOracleDataSet, ordinary TDataSource and TDataGrid. To refresh data TOracleDataSet.Refresh() is called )

Thank you!
 
That's probably easy to find out. Just use SQL Trace to find the SQL that is causing this traffic, and verify the difference with your SQL*Plus simulation.

------------------
Marco Kalter
Allround Automations
 
You must log in or register to reply here.
Back
Top