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);

Answer 1

User269602965 posted

describe the two environments

Answer 2

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.

Answer 3

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.