This content has been marked as final. Show 3 replies
can you check how many plans are using the your sqlid
select * from table(dbms_xplan.display_awr('&v_sql_id'));
there will be N number of causes like ( waits/bad stats etc.,) - for that you need to trace the query session and find where it was causing..? - trace the session and find with tkproof - and post the result
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