Home » SQL & PL/SQL » Client Tools » query hang on toad
query hang on toad [message #249452] Wed, 04 July 2007 09:38 Go to next message
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 #249463 is a reply to message #249452] Wed, 04 July 2007 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Kill the server process associated to the toad session.
You will find it in v$session.

Regards
Michel
Re: query hang on toad [message #254383 is a reply to message #249463] Thu, 26 July 2007 11:22 Go to previous messageGo to next message
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 #254389 is a reply to message #254383] Thu, 26 July 2007 11:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"kill -9" if you are on Unix.
Use orakill.exe if you are on windows:
C:\>orakill

Usage:  orakill sid thread

  where sid    = the Oracle instance to target
        thread = the thread id of the thread to kill

  The thread id should be retrieved from the spid column of a query such as:

        select spid, osuser, s.program from
        v$process p, v$session s where p.addr=s.paddr

Regards
Michel
Re: query hang on toad [message #254390 is a reply to message #249452] Thu, 26 July 2007 11:35 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
ALTER SYSTEM KILL SESSION ('sid','serial#");
Re: query hang on toad [message #256037 is a reply to message #249452] Thu, 02 August 2007 16:40 Go to previous message
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.
Previous Topic: Unable to perform operations using 'dual' table: SP2-0575
Next Topic: Using Text Importer via SQL*Plus
Goto Forum:
  


Current Time: Sun Dec 04 04:31:46 CST 2016

Total time taken to generate the page: 0.08251 seconds