Re: Help: blocks column from dba_tables and dba_segments

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

[Quoted] [Quoted] 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 - 16:49:12 CET