Re: DDL Progress ?? (index creation)

In article <imJG5.7777$oD.180425_at_news6-
win.server.ntlworld.com>,
  "crazy4" <crazy4_at_ntlworld.com> wrote:
> Is there anyway of monitoring the progress of
 an index being created?
>
>

You can look in DBA_EXTENTS for segments of type temporary and group by count for the user creating to index. Something like the following:

select segment_name, count(*)
  from dba_extents
 where segment_type = 'TEMPORARY'
   and owner = <username>
 group by segment_name

The problem with this is you could have several objects being created by that user at a given time so this query could get several segments that you cannot tie back to the index in question. looking in v$transaction by the session_address found in v$session will work also but this could be misleading since you won't be able to tell whether the index is sorting or actually building. There is probably a better solution than either of these that someone much smarter than I will know. Hope this helps

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 17 2000 - 19:29:52 CDT