Re: Got timeout writing communication packets
Have tried the query with inner join instead of left join both results are having huge different.
In addition to the details in the very first run the query got aborted and result not return to client.
After immediate the next run the query completed faster seems the second time query gets data from memory which is already loaded in the first run.
Kindly suggest which causing the first query run got aborted in the "sending to client" state in processlist.
Subject
Written By
Posted
Re: Got timeout writing communication packets
August 06, 2021 10:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.