Following scripts will help to find out the statement in Oracle Database currently Index Rebuild - Progress & Index creation Progress
select a.sid, sql_text ,target, sofar, totalwork, time_remaining still, elapsed_seconds tillnow
from v$session a , v$sql b, v$session_longops c
where a.sid=c.sid
and a.sql_address = b.address
and a.sql_address = c.sql_address
and status = 'ACTIVE';
No comments:
Post a Comment