DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TWO-TASK SERVER: error = 12571 & ORA-3113

Threaded View

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    Exclamation 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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width