Re: Index creation monitoring + select/inserts

From: madhu <madhusreeram_at_gmail.com>
Date: Tue, 6 Oct 2009 20:55:57 -0700 (PDT)
Message-ID: <e76beaac-d9b4-4dd1-8f0d-aba2b4be8277_at_r36g2000vbn.googlegroups.com>

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). Received on Tue Oct 06 2009 - 22:55:57 CDT