hi,
I'm using the following Oracle version.
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Just doing some Oracle learning here. Nothing urgent. I inserted data into a table and deleted the data. But, when I checked the empty_blocks attribute of the dba_tables table, it still showed 0. Here are the steps performed.
create table testblocks (col1 integer);
insert into testblocks values (1);
commit;
begin dbms_stats.gather_table_stats('XXXXXXX', 'TESTBLOCKS'); end;
delete testblocks;
commit;
begin dbms_stats.gather_table_stats('XXXXXXX', 'TESTBLOCKS'); end;
select * from dba_tables where table_name = 'TESTBLOCKS';
Any ideas? I even ran it by inserting 10M records into the table and it still showed 0.