Showing posts with label Oracle Index Rebuild Progress. Show all posts
Showing posts with label Oracle Index Rebuild Progress. Show all posts

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';