This content has been marked as final. Show 3 replies
user7435395 wrote:HOW To Make TUNING request
I have a query which generates a file and normally runs 10-30 mins. Now the same query has been running > 2 hours and no data output to the output file. There are no other running long queries in database beside this one. CPU load is low. what other cause could it be?
SQL and PL/SQL FAQ