Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003

    Unanswered: Prevent time-consuming queries from timing out?

    We have a huge table which we want to run a cleanup query on each night, but the query takes too long time to complete - resulting in a timeout!

    Any suggestions?!

  2. #2
    Join Date
    Apr 2004
    I'll assume that it's some sort of network connection from a web front-end that is timing out. If so, then try putting your cleanup query in a stored procedure and run it as a dbms_job. If you need to spool output from it, use utl_file.
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Jul 2003
    i suggest tuning the cleanup script and
    also breaking out your cleanup into sections and
    running a section at a time
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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