Database DataWarehousing (MOSC)

MOSC Banner

HWM Reset and Compression

edited Apr 26, 2013 6:25AM in Database DataWarehousing (MOSC) 3 commentsAnswered
Hi Oracle Gurus,
I need some information on HWM and compression.

As per my understanding HWM reset would be primarily done for couple of reasons.

1. Reduced the table size. i.e if the actual size(actual_num_rows*avg_row_len) of the table is 10G and if the in dba_segments it says 20G; then we can save approx 10G on resetting the HWM.
2. Performance Improvement; This will make sure that the empty blocks are not read from the disks. i.e the all the blocks are completely filled with the table's details and there is no need for any FTS operation to go through the empty blocks as well.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center