Stop Long running Queries
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Stop Long running Queries

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    33

    Stop Long running Queries

    I have Oracle 9.2.0.6 database on Hp-Unix. Users connect to the database using Application Server/Web Server.

    I have noticed some of the queries run for long long time.. Ex.
    Duration=36411 sec
    Duration=36091 sec
    Duration=33628 sec

    before error out with ORA-01555 caused by SQL statement below. I have the SQLs causing this displayed in Alert Log.

    My question is, Is there a way I can set sometime limit for such queries so if the SQL don't finish in lets say 10 mints or so it times out or any of my code can end/kill these SQLs?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Cool Criminal profiling?

    Create a profile to limit cpu usage or whatever composite metric you want and assign that profile to those users.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    would be better if you fixed the queries to run quicker

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