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 -> used/free space in a segment or extent

used/free space in a segment or extent

From: Henry <henry_2303_at_hotmail.com>
Date: Tue, 14 May 2002 16:21:51 GMT
Message-ID: <zQaE8.4822$t8_.223@news01.bloor.is.net.cable.rogers.com> 





Hi,


Lets say I create table with initial extent 10M so it takes 10M from a
tablespace right away.


But if the table is empty or have only few records the whole extent is not
used up...


Is it possible to see how much space is used /available within an extent??



Thanks.
Received on Tue May 14 2002 - 11:21:51 CDT












Original text of this message













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