1 Attachment(s)
TWO-TASK SERVER: error = 12571 & ORA-3113
Oracle 8.1.7 on Windows 2000 server
-----
I am getting
TWO-TASK SERVER: error = 12571
(Ungraceful disconnection of a session from the oracle db while the db is currently running a dml statement issued by that session)
&
***Got ORA-3113 while running PLSQL***
PROCEDURE TRACKER.WEEKLY_DIARY_REPORT_NEW:
(end-of-file on communication channel)
errors every 10-15 days.
----
Q. First of all are these 2 errors somehow connected.
Q. Is error ORA-03313 is being caused solely because of PROCEDURE TRACKER.WEEKLY_DIARY_REPORT_NEW.
Q. Whats the resolution to get rid of both. The above errors does not crash the DB (haven't caused it yet) but causes the system to slowdown - that procedure uses 98% of CPU when its running (no other process works until the procedure is finished executing).
Any help is much appreciated. Thanks
-D