Query struck for more than 2 days
Hello ,Below is the query struck for more than 2 days but earlier it used to complete in 40 mins
SQL> /
BLOCKING_SESSION EVENT LAST_CALL_ET SQL_ID SID
---------------- ---------------------------------------------------------------- ------------ ------------- ----------
latch: cache buffers chains 33825 3bw6jsn5t4wb9 189
Please advise.
select rows_processed from v$sql where sql_id='3bw6jsn5t4wb9';
ROWS_PROCESSED
--------------
0
Best regards,
Vishal
0