Re: Got timeout writing communication packets
Posted by: M.Manigandan Mangundu
Date: August 06, 2021 10:49AM

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.

Options: ReplyQuote

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.