Troubleshoot SQL * Plus

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

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers

gurbux

  • Jul 18th, 2010
 

SQL statement is taking long time to retrieve results from database.
See which statement is taking longtime by running SELECT * FROM sqltext; or SELECT * from v$session_longops;

  Was this answer useful?  Yes

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