I have noticed one thing in toad. if we double click on the result set grid from a query the cell change into edit mode. Although I have only read only access to database but when the cell gets into edit more then the cell is locked. due to this if other program which are trying to insert a value in cell has to wait.
i have tried one option in administration> exucute query in read only mode. but this option make the integer columns readonly and not varchar columns.
what is the solution for this.