| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Extent inffo does not match table size ?
(O 9.2.0.1.0)
Ok, so obviously I haven't quite understood something here, hope s/o can help.
When I look at the Information on my table (using Toad), it reports: STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
However, it also reports:
Table Size = 128 MB
Number of Extents = 87
So how can a table of 128MB be made up of 87 x 64KB?
As I said, obviously I've either misunderstood something or look at the wrong information :-)
thanks,
Martin
p.s.:
Tablespace:
CREATE TABLESPACE "USERS"
LOGGING
DATAFILE '&2\ORADATA\&1\USERS01.DBF' SIZE 2048M
AUTOEXTEND
ON NEXT 10240K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
/
Received on Tue Oct 10 2006 - 03:14:40 CDT
![]() |
![]() |