Good old corporate politics here. So some of this is just fishing to see to
if anyone knows of anything that has changed from 8.1.7.4 to 9.2.0.3 with
online index creation ... OR ... has there been a change made in the
application (unbeknownst to us) that will crash into an online index
creation.
I see, you can't find ot the waits because you don't want to ruin the
performance again on purpose. That makes sense!
Online index rebuild has been problematic WRT the journal application
phase (among other problems such as abandoned journal segments after
cancel or failure) since it was introduc
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 8.1.7.4. Now we try
when the database is 9.2.0.3, and we don't just see waits, we see the thin
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
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