Thread: Hwm
-
Hwm
HI,
My table has following below details
[CODE]
Free Blocks.............................3
Total Blocks............................943
Total Bytes.............................7725056
Unused Blocks...........................3
Unused Bytes............................24576
Last Used Ext FileId....................58
Last Used Ext BlockId...................165595
Last Used Block.........................300
[/CODE}
1) I see there are total 943 blocks but used are 300 and unsed are 3 blocks and free are 3 blocks
Total is 306 blocks. Where are the remaining blocks in the table.
I assume when it does full table scan it reads till 640 blocks.
To set my HWM i need to tuncate or move the table. Is there any other way I can make my HWM come to the blocks used.
2) I did use deallocate unused keep command to free the blocks, but i see still the free blocks in the table. I had 20 free blocks and came up to 3 free blocks . but it does not go down from 3 to 1.
Does HWM come down if free blocks reduce or it stays at the total used blocks ?
-
What is your oracle release?
Tamil
-
-
In 8i, you have limited options- exp,drop nad imp or move.
But why do you bother 340 blcoks extra read during FTS?.
Tamil
-
If you have an 8k block size your table would be less than 3 megs. If you are that concerned move the table. But if you keep inserting and deleting rows you might get back to a situation where you are wasting a few blocks. Besides a table like that is probably cached anyway.
Code:
alter table mytable move ONLINE tablespace newtablespace;
alter table mytable move ONLINE tablespace oldtablespace;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|