Have you retried this Query 3 -4 times.since you might have waited since output did not showed up and retried the query.ĭue to the above thing the locks on the table are kept held so login as sysdba and kill the session which are holding that locks and session which are held and they are idle and try once again.that might solve your issue. Is it First time you are facing this Issue.? Is it your Prodcution or Developemnt Environment.? Mynz You have to look into the SQL first.IT is the SQL which is causing the issue. Is there any parameter which might be set wrong ? Unusually, this output is very slow and even stops from time to time. I have a statement which is running quite a while (1-2h) and then starts it's output on SQLplus.
0 Comments
Leave a Reply. |