Re: Help: blocks column from dba_tables and dba_segments

Why do you care? Haven't you got any "real" tuning issues to deal with?

And what has the number of blocks got to do with your stated goal which is pinning the table?

Daniel Morgan

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
Received on Thu Mar 21 2002 - 09:49:12 CST