Trying to figure out something...

From: Syltrem <syltrem_at_videotron.ca>
Date: 2000/06/29
Message-ID: <NxO65.176$zu5.12546@wagner.videotron.net>#1/1

Hello all!

There is something I do not understand.

Time Action

------    ------------------------------

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 Thu Jun 29 2000 - 00:00:00 CDT