Re: Help: blocks column from dba_tables and dba_segments

Mike F wrote:
>
> Hi, Folks
> We are trying to keep the small table in the keep buffer.
>
> We have a table which has only 100 rows, but blocks from dba_tables
> and dba_segments show the table has 128 blocks.
>
> So I truncated the table and re-insert the rows back to the table.
> Now the blocks in Dba_tables shows only 4 blocks where dba_segments
> still shows 128 blocks.
>
> How can I bring down the blocks from dba_segments as well?
>
> When you keep the table in the Keep buffer, does it keep all the 128 blocks from dba_segments or it only keep the 4 blocks from dba_tables?
>
> Thanks for your help.
>
>
> --
> Sent by dbadba62 from hotmail part of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

BLOCKS in xxx_tables is the number of blocks *ever* used. BLOCKS in xxx_segments is the amount of blocks allocated to the segment (none/some/all of which may have been used)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."