Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Growth of Local Partitioned Bitmap Indexes
Notes in-line.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0401090938.30c31d43_at_posting.google.com...Received on Fri Jan 09 2004 - 12:36:49 CST
> Any change in the from or to value will lock them all -- test it. I
> did a long time ago with a simple two column table (name and gender)
> -- alot of people undergoing sex changes!
>
Option 1: you didn't test it properly Option 2: it was a long time ago, in a distant country ... Maybe you had a version with a bug. Your test case was probably too small - giving you the impression that the whole set of rows was locked. With an 8K block size you are likely to need around 30,000 rows in a table before the bitmap for a key value requires more than one chunk. The lock is per index chunk, not per key value.