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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
