Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: Online index creation on 9.2

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Thu, 29 May 2003 09:05:03 -0800
Message-ID: <F001.005A5B51.20030529090503@fatcity.com>


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."

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 29 May 2003, Stephen Lee wrote:


>
> On 9.2.0.3, I have experienced a problem with online index creation. When
> creating indexes on what I suppose most would consider to be large tables
> (with nasty, sharp, pointy teeth and a bad disposition), when Oracle is
> doing its initial data gathering, sorting, slicing, and dicing in
> preparation for the actual creation of the index, it appears that "normal"
> access to the table -- and this includes selects which do not modify data --
> becomes severely reduced to the point that the application is no longer
> usable. When Oracle finishes with its fact finding mission and begins to
> build the index (as evidence by the appearance of a segment with a number
> for a name), everything is OK again. We never had this problem with
> 8.1.7.X.
>
> Is this a new "feature" of 9.2.0.3? Is there some new magic parameter that
> needs to be set? Are we wearing the wrong grass skirts and/or incorrectly
> performing our ritual sacrifice ceremonies?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: jwilton_at_speakeasy.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 - 12:05:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US