Skip to Main Content
  • Questions
  • Explaination on LRU, MRU and MFL,TFL

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Surendar.

Asked: August 20, 2017 - 10:44 am UTC

Last updated: August 23, 2017 - 2:47 am UTC

Version: Oracle 11g R2

Viewed 1000+ times

You Asked

Dear Tom,

I have basic knowledge on what is MFL,TFL,PFL and hash bucket. it would be great if u can explain further in deepth.
But here I want to know how LRU and MRU are used/mingled with MFL,TFL.
I have gone throw many links of oracle but unable to get the details.
Would you please help me in understanding this.

Thanks

Regards,
Surendar


and Connor said...

I have NFI what MFL or TFL or PFL is referring to, so all I can say is WTH.


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Maybe?

Racer I., August 21, 2017 - 7:42 am UTC

Hi,

https://www.scribd.com/presentation/3321828/Poder-Freelists-vs-ASSM

Talks about :
Three Types of Freelists
•Segment Freelist or Master Freelist (MFL)
–The default, also called common pool
•Process Freelist (PFL)
–Is created with FREELISTS clause
•Transaction Freelist (TFL)
–Used implicitly when DML reduces block spaceutilization under PCTUSED
•Every freelist Group uses one extra datablock after segment header
–Consists of MFL, PFLs and TFLs

Connor McDonald
August 23, 2017 - 2:47 am UTC

I actually knew what they were...because I know Tanel and his work very well, but that's no excuse for a question being a jumble of acronyms with no further explanation because what of the *next* reader who comes along to AskTOM.