Oracle - SMTP email leads to very high TCP Socket (KGAS) events
Posted on 2013-09-17
We have an oracle-procedure that will handle all the emails sending out from our application. This is now already running for a long time without any problems.
Now we changed from smtp-server and we encounter a lot of TCP Socket (KGAS) events.
This can lead to timeouts and thus not sending out the email(s)
We performed an investigation and noticed that it occurs at the following statement:
UTL_SMTP.rcpt( psMailconn, psRecipient );
Now we are adding 10, 50 or even 500 email receivers without any delay on the previous servers.
What can cause this event ?
How can we overcome this when adding the receivers ?
Is this a smtp-server issue (mailserver) or an oracle issue ?