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!

ASSM data structure question

OracleGuy777Dec 1 2008 — edited Dec 2 2008

hi guys,

Can someone please clarify this for me? I am looking at the presentation "Freelists vs ASSM in Oracle9i" by Tanel Poder, and on slides 19 he talks about the ASSM segment and ASSM segment header. I am just a little confused. if we have ASSM, and we create a table, then does that mean that an ASSM segment is created for that table too? i.e. we'll have two segments, one for the table, and an ASSM segment for it?

Or, is only one segment created (for the table), and the L1 BMB reside in segment header of that table, and the L3 BMB reside in the first data blocks of each extent of that segment? is this correct? if so, where do the L2 BMBs reside?

thanks

This post has been answered by Jonathan Lewis on Dec 2 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2008

Added on Dec 1 2008

#general-database-discussions

8 comments

1,293 views