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!

Freelists and Highwater Mark

819156Jan 4 2011 — edited Jan 4 2011
Dear Gurus,
I have been reading the concepts carefully to understand each and every point (as a beginner). I am stuck in one place, the concepts (Chapter 2 Overview of Data Blocks)

The paragraph says:
Although you can allocate additional extents, the blocks themselves are allocated separately. 
If you allocate an extent to a specific instance, the blocks are immediately allocated to the free list. 
However, if the extent is not allocated to a specific instance, then the blocks themselves are allocated only when the high water mark moves.
The high water mark is the boundary between used and unused space in a segment.
I could not understand what is Freelist and what is High Water Mark. As a beginner I was asked to start with Oracle concepts and I could not comprehend this information. Can some experts help?

Thanks
Neel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2011
Added on Jan 4 2011
5 comments
168 views