query hang on toad [message #249452] |
Wed, 04 July 2007 09:38 |
ammishra
Messages: 179 Registered: January 2007 Location: india
|
Senior Member |
|
|
Hi,
I have run one query on toad which got hang. How can I terminate this query.
--Yash
|
|
|
|
Re: query hang on toad [message #254383 is a reply to message #249463] |
Thu, 26 July 2007 11:22 |
ammishra
Messages: 179 Registered: January 2007 Location: india
|
Senior Member |
|
|
i have run the following commnd
select * from v$session where OSUSER='ammishra'
i got the SID ..now how can i kill the session ..i mean what is the command ..
|
|
|
|
|
Re: query hang on toad [message #256037 is a reply to message #249452] |
Thu, 02 August 2007 16:40 |
charansundaram
Messages: 8 Registered: August 2007 Location: INDIA
|
Junior Member |
|
|
Hi,
Befor running query , check through explain plan. In toad
write query and press CTRL + E. If you get TABLE FULL ACCESS
or high cost . Then redefine your query.
|
|
|