Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Online index creation on 9.2

RE: Online index creation on 9.2

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Thu, 29 May 2003 13:51:09 -0800
Message-ID: <>

I appreciate the response. The questions here are not "Are there waits?" Most obviously, there are. The questions flying around here are: We have been doing this with no problems when the database was Now we try when the database is, and we don't just see waits, we see the thing go right into the dirt. So question is, does have "issues" with online index builds on large tables in a large database? We have a TAR going, and we are going to try to figure out a way we can get some diagnostics going. There is no way management is going to allow us to do this on the production database. It would have been nice if a big mess of diagnostics had been running at the time. But it wasn't (other than spotlight -- OK, I use _ONE_ GUI), and when you're up to your ass in alligators, it's hard to think much about draining the swamp. I suspect what we will try to find out is what type of transactions would be most affected and get with the application people to see if we find some correlation.

> -----Original Message-----
> What are the wait events of the slowed sessions?
> What is the correspondence with v$session_longops phases for the
> rebuild?
> Really, the answer to 75% of the questions in this group is "look at
> v$session_wait."

Please see the official ORACLE-L FAQ:
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu May 29 2003 - 16:51:09 CDT

Original text of this message