This content has been marked as final. Show 4 replies
Robert wrote:Identify the oracle session and kill it..hurry up!
I have created an email functionality in APEX 3.0.1.00.08 using the following procedures:
DB VERSION: 10.2.0.4.0
P_TO => P_TO,
P_FROM => v_from,--p_from,
P_BODY => p_mailbody,
P_BODY_HTML => p_mailbody_html,
P_SUBJ => p_subject
I am using the the above mentioned two procedures in a page process. In the page process I defined two cursors:
1. cursor: I select the email adresses (P_TO).
2. cursor: I define the number of emails that should be sent to the selected email adresses. At this step we commeted an error: our cursor delevers us more than 1.000.000 records.
So we have been reciewing anormus number of emails for 12 hours without end.
Is there any way to stop/empty the procedures?
thank you for your rapid answer!
we identified the session and we marked it for "killing" on database level (SQL Developer).
Furthermore we also killed the session on oparating system level with the statment: "kill -9 >spid<".
Problem solved! Thank you!
FYI - Beginning in APEX 4.2, there is now a per-workspace limit for emails. The default is a 1,000 per workspace in a rolling 24-hour period. You should consider upgrading sometime (as APEX 3.0.1 is no longer supported).