NUM_FREELIST_BLOCKS

Does NUM_FREELIST_BLOCKS from DBA_TABLES show the number of blocks on the segment's master free list? What if this number is quite high in the hundreds or thousands? As each user maintains their own process free list, is there ever a time when you must walk the entire master free list? These tables all have LONG columns and PCT_FREE=10 and PCT_USED=40. Could a high number here lead to contention for the segment header?

Thanks. Received on Mon Jul 29 2002 - 14:31:49 CDT