Re: Lack of performance using utl_smtp

> I'm using utl_smtp to send emails out of the database, but I'm having
> serious performance troubles.
>
> I'm sending the exact same email to 800 persons, when I send it it will
 take
> approx 150 minutes to complete this task.
>
> I've measured it and utl_smtp only sends approx 5 messages each minute!!!
>
> Anyone familiar with this problem and a possible solution?

yep, I had the same problem. Increased Java-Pool up to 50M and the main thing was the HELO-String. The performance of the system dramatically inreased (5 Mails a second) as I changed the HELO-command to the name of the smtp-host. like this:

smtp := UTL_SMTP.Open_Connection( SMTP_Host);

UTL_SMTP.HELO( smtp, SMTP_Host );

hth,
Uli Received on Fri Feb 16 2001 - 04:39:24 CST