On 09/28/2018 12:51 PM, Arup Rakshit wrote:
How often does the production app make this call? Apparently it could do it 500 times per second. But at such a rate the network overhead would be stupendous - you might think about getting more data per call, few calls.Yes, I have shown the explain plan output. But in my application log the sql query prints 1.7 to 1.9 ms.
