Re: Fragmentation of tablespace

But the bitmap is a data block, so it will be kept in the db_block_buffer and follow the normal LRU algorithm, so heavy
usage won't be made worse.

There will be performance side effects on viewing dba_free_space, dba_segments,
dba_extents because of the new methods,
but you shouldn't be doing this too much, and dba_segments is pretty bad now anyway because of the massive union all view of the numerous different segment types
available in 8.1

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Connor McDonald wrote in message <3944ED7C.37C8_at_yahoo.com>...



>The only one I know of that the bitmap is not cached thus you need to

>visit the disk for extent allocation - thus if you had a tspace that was

>having heavy extent allocation (eg for temporary creation/drop of

>objects) then maybe dictionary based would be better...

>