Re: Online index creation on 9.2

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