Re: does delete records free up dbspace?

> hi all: > I deleted a bunch of records from my database, around 1/3, but when I > do a onstat -d, the dbspace usage remain the same, how could that be? if > that's the case, how could I tell how full my database is at a given time? > thanks a lot. btw, i am running 7.22 with solaris 2.6 > yan That's how it works...check the manual. From the administrator's guide: "After disk space is allocated to a tblspace as part of an extent, the space remains dedicated to that tblspace even if the data contained in it is deleted. For alternative methods of reclaiming this empty disk space, see your Performance Guide." You can see how much space is left by checking the system tables.