SET QUERY TIME OUT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SET QUERY TIME OUT

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Question

    is there a way to set the sql query time out on the database, if it is taking too long to process?

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Client side? - Depends on the tool. Some tools have the capability to break.

    Server side? - You could use a db monitoring tool to alert you to this problem. Then manually kill the query after assuring that it's OK.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    What version, 8, 9?
    ovidius over!

  4. #4
    Join Date
    Mar 2002
    Posts
    9

    Thumbs up

    Oracle 9i Resource Manager provides a new feature that facilitates the prevention of execution of operations that are estimated to run for a longer time than a predefined limit.

    This can be accomplished by doing the following:

    While creating a resource plan directive you need to specify the parameter

    MAX_EST_EXEC_TIME

    For example you can create a plan to specify a maximum execution time limit of 10 minutes by specifying the parameter in the following procedure
    DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (,MAX_EST_EXEC_TIME =>600,..);

    Oracle calculates the time taken for a SQL statement based on statistics available and rejects the statement if the calculated estimated time is more than the set limit.

    Hope this helps.
    - Kolagani
    OCP 8i,9i DBA,SCJP, BEA WLS6CD

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