Dieter, May 30, 2022 - 10:11 am UTC
ad 1) This makes sense and is pretty much what I'm trying to do, but it is sometimes quite difficult to guess when temporary lobs are handed down to many levers of procedural code. I typically cache the LOB when I can not be sure if it will be "worked with".
ad 2) This is what I'm constantly struggling with because even if the original LOB is reasonably small it might grow and completely pollute my buffer cache.
May 31, 2022 - 1:55 am UTC
Even with a large lob, the buffer cache algorithms are pretty sophisticated, so we're pretty good at ensuring we don't whack the entire cache.
So I wouldn't lose too much sleep over it