Sample project source: http://s000.tinyupload.com/?file_id=005 ... 2537543799 (78 KB)
With a 9.5.15 single occurrence on TSmartQuery.Open call only.
With a 9.6.22 occurrences on TSmartQuery.Open call and also on each TOraProvider.GetRecords call.
Multiple TOraSQLMonitor.OnSQL occurrences by one query
Re: Multiple TOraSQLMonitor.OnSQL occurrences by one query
We have investigated behavior of TOraProvider using your sample on ODAC versions 9.5.15 and 9.6.22 . Unfortunately, we found no difference in behavior of TOraProvider between these versions. We are going to discontinue support for TOraProvider shortly. Instead of it, for work with ClientDataset, you can use the TDataSetProvider component distributed with Delphi IDE