Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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