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: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 13 Jan 2003 12:38:39 -0800
Message-ID: <F001.0052E30A.20030113123839@fatcity.com> 





Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was
that a great version). 



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com 




-----Original Message-----



Sent: Monday, January 13, 2003 1:22 PM


To: Multiple recipients of list ORACLE-L




Dennis,



Here/ in this senario '


'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except 
to anlyze table with cascade structure which will reveal any index 
corruption relating to that table. There was a bug in 7.3.4.3 where index 
rebuilding with parallel clause was resulting in corrupt indexes with 
multiple keys. Indexes with single index key were ok...



I think it should be the problem....



Regards


Rafiq










Reply-To: ORACLE-L_at_fatcity.com


To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Mon, 13 Jan 2003 09:29:04 -0800



Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a
little rusty. If you search METALINK, you will find quite a few issues with
this command on various Oracle versions. I believe that the basic principle
is the same - Oracle builds a new index in the background, syncs up any
table changes that have been made since the index build began, then switches
which index is being used for queries. I think I heard somewhere that the
locking/syncing mechanism has been improved in more recent Oracle versions.
Perhaps someone else on the list has some specific knowledge. The database
doesn't need to be in exclusive mode, but common sense would be to avoid
rebuilding when the table is being heavily modified. Once you complete, you
can ANALYZE INDEX VALIDATE STRUCTURE just to be sure you don't have any
problems.



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com




-----Original Message-----



Sent: Monday, January 13, 2003 10:14 AM


To: Multiple recipients of list ORACLE-L




ALTER .......REBUILD..


Thanks



COnrad..




-----Original Message-----



WILLIAMS



Sent: Monday, January 13, 2003 10:19 AM


To: Multiple recipients of list ORACLE-L




Conrad - What command did you use to re-index? Drop index / create index?



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com




-----Original Message-----



Sent: Monday, January 13, 2003 8:44 AM


To: Multiple recipients of list ORACLE-L





Sorry, I forgot this additional infromation...



Oracle created invalid objects when we ran rebuild.  The odd thing was that
the trace file showed an invalid object but the all_objects table showed a
valid object.





-----Original Message-----



Sent: Monday, January 13, 2003 9:39 AM


To: ORACLE-L_at_fatcity.com





Team,



I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode.
While the users were on the system, we Re-Indexed our tables.
Situation: The users complained, that they were unable to process their
orders.


Although, the log file showed that the re-indexing was successful, the users
were still unable to process their orders.




QUESTION: Are they any known issues/pit-falls when re-indexing real-time in
version 7.x?



Should you have the database in exclusive mode when re-indexing?



Please assist.



Thanks



Conrad Meertins



cmeertins_at_pinnacle-data.com



DBA Masters




--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author: Conrad Meertins


   INET: cmeertins_at_pinnacle-data.com


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


--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author: DENNIS WILLIAMS


   INET: DWILLIAMS_at_LIFETOUCH.COM



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



--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author: Conrad Meertins


   INET: cmeertins_at_pinnacle-data.com


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


--



Please see the official ORACLE-L FAQ: http://www.orafaq.net


--



Author: DENNIS WILLIAMS


   INET: DWILLIAMS_at_LIFETOUCH.COM



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






MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus



-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: M Rafiq


  INET: rafiq9857_at_hotmail.com


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


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: DENNIS WILLIAMS


  INET: DWILLIAMS_at_LIFETOUCH.COM



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 Mon Jan 13 2003 - 14:38:39 CST












Original text of this message













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