Database Tuning (MOSC)

MOSC Banner

rows_processed in v$sql is 0

edited Jul 24, 2013 11:52PM in Database Tuning (MOSC) 16 commentsAnswered
A delete statement running for 2 hrs but rows_processed in v$sql is 0

SQL> select event, sql_id,last_call_et ,program,module from v$session where status='ACTIVE' and username<>'SYS';

EVENT                                                            SQL_ID
---------------------------------------------------------------- -------------
LAST_CALL_ET PROGRAM
------------ ------------------------------------------------
MODULE
----------------------------------------------------------------
db file sequential read                                          bm1c33g791t2n
        4504 Toad.exe

SQL> select rows_processed from v$sql where sql_id='bm1c33g791t2n';

ROWS_PROCESSED
--------------
             0

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