Been playing around.... When will Oracle attempt to reuse the space freed up by deletes? Seems like Oracle tends to insert farther down the heap, even if there is free space at the head of the table?
Please see below?
rgaffuri> create table x (y number);
Table created.
rgaffuri> insert into x values(1);
1 row created.
rgaffuri> insert into x values(2);
1 row created.
rgaffuri insert into x values (3);
1 row created.
rgaffuri> select y from x;
1
2
3
rgaffuri> delete from x where y = 1;
1 row deleted.
rgaffuri> select y from x;
2
3
rgaffuri> insert into x values(4);
1 row created.
rgaffuri> select y from x;
2
3
4
If I insert 5 next, in what case would I see
select y from x
5
2
3
4
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Aug 27 2004 - 09:39:43 CDT
