Re: Are BLOB blocks put in buffer cache ..

On Mar 12, 7:57 pm, dbaplusp..._at_hotmail.com wrote:
> I have some tables which contain large blobs (attachment such as .jpeg
> files are stored). I am using blob type have a separate tablespace for
> using blobs.
>
> When I read this table and process blob, i.e., read through all of
> blob and create a file .jpeg, will all blocks of blob go through the
> buffer cache and will they push everything out of the db_cache.
>
> I looking at the contents of buffer cache and somehow do not see blobs
> filling up my cache, that is why posing this question. If blobs take
> away lot of space in cache, I will like to put them in recycle pool.
>
> Thanks,

By default LOB segment IO's are not buffered, that is, by default every read or write required a physical IO to take place. Only that portion of a LOB stored inline is buffered by default. You have the ability to change this via the LOB storage parameters.

HTH -- Mark D Powell -- Received on Mon Mar 12 2007 - 20:10:08 CDT