Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Are BLOB blocks put in buffer cache ..

Re: Are BLOB blocks put in buffer cache ..

From: Mladen Gogala <mgogala.SPAM-ME.NOT_at_verizon.net>
Date: Wed, 14 Mar 2007 20:21:19 +0100 (CET)
Message-ID: <pan.2007.03.14.19.17.57@verizon.net>


On Mon, 12 Mar 2007 16:57:23 -0700, dbaplusplus 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.
>

Unless you specify CACHE or CACHE READS option during create table command, your LOB type objects are written and read using direct writes and direct reads, from the database into PGA and back.

-- 
http://www.mladen-gogala.com

-- 
http://www.mladen-gogala.com
Received on Wed Mar 14 2007 - 14:21:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US