Without getting into a debate about whether an index needs rebuilt as this is an area that i'll get into in the future once i've learned a LOT more, sometimes its good to be able to know how an index rebuild is going.
SELECT MESSAGE
FROM V$SESSION_LONGOPS
WHERE SID IN (SELECT SID
FROM V$SESSION
WHERE USERNAME='SYS' AND STATUS='ACTIVE')
ORDER BY START_TIME;
If you have a spare couple of hours and want to learn more about indexes , Index Internals would be a good place to start where some very good case studies are carried out and myths challenged.
No comments:
Post a Comment