Saturday, 20 December 2014

Find the index which are " Index Rebuild - Progress & Index creation Progress"

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