SQL Performance (MOSC)

MOSC Banner

Query struck for more than 2 days

edited Nov 3, 2013 7:58PM in SQL Performance (MOSC) 11 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center