Answered by:
Production Vs Staging with Oracle with UTL_MAIL.SEND

Question
-
User-1188570427 posted
Has anyone ran into issues when sending email in a production environment and seeing slowness compared to your staging environment? We are using utl send mail (code below) to do our emails from the database via a stored procedure. When we go to production it is VERY slow. It will only send an email every 5 seconds. In staging/development it runs fine. Anyone have a clue how this could be fixed or is it something with the mail server? Does utl send mail wait for a response from the smtp server? Can something be changed on how utl send mail is set up on the production server?
UTL_MAIL.SEND ( sender IN VARCHAR2 CHARACTER SET ANY_CS, recipients IN VARCHAR2 CHARACTER SET ANY_CS, cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL, message IN VARCHAR2 CHARACTER SET ANY_CS, mime_type IN VARCHAR2 DEFAULT 'text/plain; charset=us-ascii', priority IN PLS_INTEGER DEFAULT NULL);
Thursday, September 25, 2014 8:00 PM
Answers
-
User269602965 posted
Usually it is SMTP server issues, like it doing reverse DNS lookup for every email request send by Oracle, firewalls and intrusion detection, malware checking, etc.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, October 2, 2014 10:28 AM
All replies
-
User269602965 posted
describe the two environments
Friday, September 26, 2014 6:27 PM -
User-1188570427 posted
describe the two environments
Well one is production and the other is staging. Other than that I don't know how they are set up etc. Sounds like it is on the SMTP side though and oracle can push 50,000 emails as long as the SMTP server can process it at a reasonable time.
Wednesday, October 1, 2014 9:54 PM -
User269602965 posted
Usually it is SMTP server issues, like it doing reverse DNS lookup for every email request send by Oracle, firewalls and intrusion detection, malware checking, etc.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, October 2, 2014 10:28 AM