Thanks for the question, DAVID.
Asked: August 04, 2017 - 6:19 am UTC
Last updated: August 05, 2017 - 2:31 am UTC
Version: 11G
Viewed 1000+ times
You Asked
Hi,
We recently encountered a connection limit on UTL_SMTP of 16 open connections. This is not because connections are being left open its just that we have reached a threshold of the number of applications utilising the UTL_SMTP package on our older databases (9i).
What I would like to know, is does this connection limit exist in the UTL_MAIL package on the 11G or 12C database? If it does then we will look to pushing the mails out via the UNIX layer rather than through ORACLE.
Your help as always is greatly appreciated.
Regards
David
and Connor said...
"This is not because connections are being left open its just that we have reached a threshold of the number of applications utilising the UTL_SMTP package on our older databases (9i)."
I'm dubious of this statement, because 16 is the limit *per session*, not instance wide. So the question I'd be asking is - why do you have 16+ concurrent open mail sessions in a single session.
It's not a UTL_SMTP or UTL_MAIL limit per se, but a underlying TCP limit.
See MOS Note 1346088.1 for details.
Is this answer out of date? If it is, please let us know via a Comment