Hi,
I have a PL/SQL Program that calls a function that normally runs under an
hour. It looks to be hung up on the function call est over 50 hrs to run.
I have gone into OEM and killed it immediate. It marks the session for
killed but it looks like it is continuing along. 2 questions, First is is
there any way to kill it right away. The table it is writing to can be
recreated so there is no harm there. Also, why would a function not
perform all of a sudden? I just recently reloaded the table that it calls,
could that be the issue?
Thanks


Kevin J Kenny
Manager of Support Services
Clinical Practice Management Plan
Stony Brook, NY 11790-0988
631-444-0595
Kevin.[Email address protected]

NOTICE: This e-mail and the attachments hereto, if any, may contain
privileged and/or confidential information. It is intended only for use
by the named addressee(s). If you are not the intended recipient of this
e-mail, you are hereby notified that any dissemination, distribution or
copying of this e-mail and the attachments hereto, if any, is strictly
prohibited. If you have received this transmission in error, please
immediately notify the sender by telephone and permanently delete this
e-mail and the attachments hereto, if any, and destroy any printout
thereof.

Oracle LazyDBA home page