anyway to cause UTL_MAIL to timeout?
Guess2May 7 2013 — edited Jun 6 201311.2.0.3
We run into KGAC TCP waits that never end. I know why this is happening. We don't have very good hardware in our DEV/TEST environments. The server with the email on it is flooded and gets hung up. However, even if we reboot the server and shut stuff off, Oracle still hangs on KGAC TCP waits until killed. I can run the UTL_MAIL procedure from another sessions once the server is bounced, but the session stuck on KGAC TCP waits, hangs indefinitely until killed. I am hoping that UTL_MAIL has some form of timeout. I don't see it in the API. I was hoping someone may have noticed something that I missed or found a way to do this. I am looking for an option other than killing the session. Another company has the production contract and it is unlikely I can get a kill session procedure created in production even if it only allows me to kill this one job. Due to company process I cannot get a job/procedure created in our Test environment unless it is under change management and going to production. So my hands are kind of tied with this.
I looked at the API, but I do not see a flag for a timeout. I was hoping there is a way to do this... If the email takes to long to run, it just errors out. I know its unlikely, but I thought I would ask.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_mail.htm