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

Thread: A TOAD Issue

  1. 12-02-2002, 04:12 PM #1
    hemanr
    hemanr is offline Senior Member
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    A TOAD Issue

    Hi Gurus,

    I have heard repeatedly that TOAD locks up a database.
    Is this true and if so how?

    Thanks!
    Hemant
    Reply With Quote Reply With Quote
  2. 12-02-2002, 04:21 PM #2
    ramaral
    ramaral is offline Member
    Join Date
    Mar 2001
    Posts
    144
    It may do it just like any other program by running a very sql statement. But no it does not lock up the database. I have used for a little over 4 years and have never seen that happen.

    But if you do run a long running statement Toad itself can appear to lock unless you change a setting with the options within it to allow the user to cancel the query that they just ran. Is this what is meant?
    Reply With Quote Reply With Quote
  3. 12-02-2002, 08:50 PM #3
    eyen
    eyen is offline Member
    Join Date
    Jun 2000
    Posts
    117
    TOAD 7.4 has a Quest ScriptRunner that opens a seperate application thread to run long running queries.
    E. Yen
    OCP DBA 8, 8i, 9i
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width