Niall - my peer is a part of offshore team and has to update the dba team sitting in client place regularly . People there are more curious about this job's progress (not sure why) and keep asking for frequent updates. That was the reason he wanted to know it . He was saying there is a view (other than session_longops and dba_indexes) which would give all these details . I was not aware of it and so posted here . ~ jp ~