Re: Index creation monitoring + select/inserts

From: briandba <>
Date: Wed, 7 Oct 2009 01:42:25 -0700 (PDT)
Message-ID: <>

On 7 oct, 05:55, madhu <> wrote:
> On Oct 6, 4:02 pm, briandba <> wrote:
> > Hi,
> > i'm new to oracle (i'm from db2) eand i have basics questions on
> > oracle 9i and 10g:
> > how can i view the progression of a create index or alter index
> > rebuild ?
> > there is no entry in v$session_longops for these orders
> Fore creation or rebuild, try querying  v$session_longops to get an
> indication of progress or amount of work left.
> Also, for creation of index, if you query dba_segments  based on
> tablespace you will find a weird named segment (with numbers). That's
> the "TEMP" segment as the index is being built, once index creation
> finishes, the weird segment will now have the actual name of index.
> The size from the dba_segments is indicative of how much of it is
> built (assuming you have a fair idea of final size).

thanks i will check this, it's works too for online rebuild ? Received on Wed Oct 07 2009 - 03:42:25 CDT

Original text of this message