locked
Production Vs Staging with Oracle with UTL_MAIL.SEND RRS feed

  • 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