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

Home -> Community -> Usenet -> c.d.o.server -> hangs on index rebuilt

hangs on index rebuilt

From: Marco Vannini <m.vannini_at_tinCANCELLA.it>
Date: Mon, 19 Apr 2004 16:34:40 +0200
Message-ID: <6sRgc.7265$l27.1779@news.edisontel.com>


Hi all.
Session hang with a 'waited too long for a row cache enqueue lock!' during an index rebuilt after a direct load (with skip_index_maintenance) into a large subpartition-composite table. I realized that the problem concerned 2 newly created function-based bitmap indexes, built on the same field: index1: 'create bitmap index fbx_tab1_1 on tab1(substr((fieldx),1,1)) local tablespace ts_index;'
index 2: 'create bitmap index fbx_tab1_2 on tab1(substr((fieldx),2,1)) local tablespace ts_index;'

I didn't get any problem in creating them, but when I load new data in a new empty partition and then perform 'alter table tab1 modify subpartition new_subpartition rebuild unusable local indexes' the process hangs and the alert reports the message above. After having dropped those indexes everything it's ok; but since it would be useful to have them, how can avoid this problem?
thanks Received on Mon Apr 19 2004 - 09:34:40 CDT

Original text of this message

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