Monitoring Oracle index rebuild progress
06 January 2004 12:00

Today I asked the ORACLE-L list about ways to monitor the progress of an Oracle index rebuild (index rebuilds on a live system when you don't have EE are no fun). One suggestion was to use v$session_longops, which looks interesting. Tanel Poder, on the list, said this:

Check v$session_longops view, it is meant for monitoring this kind of long-running jobs - but it can be quite inaccurate. Another way would be to check v$sort_usage during sorting phase of index recreation and then check the newly created index segments size (it'll be created as a temporary segment initially and switched to index-type afterwards).

Monitoring the creation of the new temporary segments/extents was something I thought of initially, but I'd like to see how accurate v$session_longops is.