Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

In ASSM, Low HWM & HWM

MUSICOVERYMay 6 2015 — edited May 6 2015

Hi,

I can easily understand HWM in a MSSM segment.

But, i can not understand the HWM and low HWM in a ASSM segment clearly.

People says, where the blocks before reaching low HWM, are formatted and used.

And after high HWM, that areas(blocks) are not formatted and not used.

(Sorry, I do not know English language well, so above expression might be wrong..)

please explain me with a simple example like:

- When a segment is firstly created, where is the position of low HWM & high HWM

- When first row is inserted

- When next extent is allocated

plus, what is the area for, between low HWM & high HWM.

Thanks in advance.

This post has been answered by Aman.... on May 6 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2015
Added on May 6 2015
8 comments
1,375 views