Re: Index creation monitoring + select/inserts
From: briandba <briandbaora_at_gmail.com>
Date: Wed, 7 Oct 2009 01:42:25 -0700 (PDT)
Message-ID: <ae253432-55a9-422f-a557-330096a3ba72_at_p36g2000vbn.googlegroups.com>
On 7 oct, 05:55, madhu <madhusree..._at_gmail.com> wrote:
> On Oct 6, 4:02 pm, briandba <briandba..._at_gmail.com> 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).
Date: Wed, 7 Oct 2009 01:42:25 -0700 (PDT)
Message-ID: <ae253432-55a9-422f-a557-330096a3ba72_at_p36g2000vbn.googlegroups.com>
On 7 oct, 05:55, madhu <madhusree..._at_gmail.com> wrote:
> On Oct 6, 4:02 pm, briandba <briandba..._at_gmail.com> 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