Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> fragmentation
Hello all!
There is something I do not understand.
16:50 try to create table of 5 MB (minextent 5M). error ORA-1658 (not enough
room)
16:52 select bytes from dba_free_space where tablespace_name ='xx';
--> 3 rows shown, all showing less than 5MB (of course)
16:55 alter database datafile 'xx' resize 700M;
--> meaning 'add an extra 50M'
17:00 create the table again. Works this time.
17:02 select bytes from dba_free_space where tablespace_name ='xx';
--> now shows 24 rows. Some with small values in the BYTES field. Why?
Why does Oracle fragment my tablespace like this? Even after COALESCE, it is the same. I have 45MB free, all in small chunks.
Can someone explain? Received on Mon Jun 26 2000 - 00:00:00 CDT