usr080678 wrote:This indicates that an Oracle process, as a TCP client in a network client-server conversation, is waiting on a response from the server. That could be due to the TCP server being slow. Could be due to network congestion. Could be due to a poorly configured network (e.g. NIC running half duplex). Etc.
TCP socket(KGAS) wait event, it creates 20% wait, is there any way to reduce, this happend when we use UTL_SMTP package.
usr080678 wrote:You are looking at the wrong software. TCP sockets are TCP socket. Oracle uses the exact same client TCP socket interface from UTL_TCP (on which UTL_SMTP runs), than what Perl uses.
hi, thanks for your reply, i did SMTP server response test manually by using perl script, 0.003 seconds test email were delivered even with 6MB attachment, that's why am looking from oracle stake to address.
usr080678 wrote:No it is not. The PL/SQL code using client socket connection very clearly states that the code is waiting on server TCP responses.
Actually SMTP Server response is very fast and tested,
i need to explain this to application team if they have to correct their codeFrom Oracle® Database Reference guide: