If the SQL * Plus hangs for a long time, what is the reason

Showing Answers 1 - 5 of 5 Answers

akebono

  • Jul 27th, 2005
 

Use hanganalyze 
 
ALTER SESSION SET EVENTS 
'immediate trace name hanganalyze level 5'; 

J Lehew

  • Aug 25th, 2005
 

You are running a cartisian query, typically by mistake. Make sure every table has a join criteria specified for it. 
 
You are working on a table with 100+million rows. 
 
The database server is busy doing a backup. 
 
Check the disk IO for the process that appears hung and if the disk IO is increasing every 5-10 seconds then the job is not hung, it is just taking a while to complete. 
 

Natesh

  • Apr 26th, 2007
 

when we try access a  table which is locked or manipulated by another user

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions