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: empty block vs no. freelist blocks

Re: empty block vs no. freelist blocks

From: Ben <balvey_at_comcast.net>
Date: 23 Mar 2006 10:13:48 -0800
Message-ID: <1143137627.938299.25770@i40g2000cwc.googlegroups.com> 





I should have mentioned this is on a DMT, I guess that is evident from
even posing the question though. I now have more concerns as I am
finding tables with 4 Gig of blocks on the freelist and a couple
hundred Meg as empty blocks. I know the correct answer is migrate to
LMT with ASSM, but that is a little easier said than done on a 400G
production database. For the time being I need to fix the problems at
hand. ugnh.



More questions though.



What is the relationship between the segment hwm and the free space
that shows in dba_free_space?



Are empty blocks above or below segment hwm?



Does the freelist include empty blocks?



What would cause such a high number of blocks on the freelist? Large
deletes?
Received on Thu Mar 23 2006 - 12:13:48 CST












Original text of this message













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