Re: Progress report on CREATE INDEX

From: <bill_buchan_at_my-deja.com>
Date: Fri, 05 Jan 2001 09:18:47 GMT
Message-ID: <9343hk$3og$1@nnrp1.deja.com>

I'm on 8.1.6.
I did have a look at v$session_longops but there was no entry for the session creating the index (still not finished yet!).

Thanks
- Bill.

In article <3a5577d6_at_news.iprimus.com.au>, "Howard J. Rogers" <howardjr_at_www.com> wrote:
> Version? What about v$session_long_ops? -but it's version-specific.
>
> Regards
> HJR
>
> <wbuchan_at_uk.noha-systems.com> wrote in message
> news:9326op$em4$1_at_nnrp1.deja.com...
> > I'm creating an index on a big table.
> > I can see it slowly consuming lots of sort space in v$sort_usage.
> > Is there any better indication of progress? I'd like to have some
> > idea when it's going to finish!
> >
> > Thanks
> > - Bill.
> >

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 05 2001 - 03:18:47 CST