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 -> Re: Growth of Local Partitioned Bitmap Indexes

Re: Growth of Local Partitioned Bitmap Indexes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 9 Jan 2004 18:36:49 -0000
Message-ID: <btmsc8$g3v$1$8302bc10@news.demon.co.uk>

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

> 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.
Received on Fri Jan 09 2004 - 12:36:49 CST

Original text of this message

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