Re: [Q] wait time /lob def

Hi Jonathan,

> I don't think the last one appeared until 9.2
> I was wrong about caching only writes, though -
> one of the joys of trying to quote everything from
> memory.

Thank you for this note, I had somehow missed this important improvement.

>
> The CACHE READS option means that the
> LOB goes into the buffer cache for reads, but
> not for writes. Pity, really, because I'd quite
> like to see it the other way around.

It guess it has to do with the kernel cache layer, that it's probably not feasible to start modifying cache layer code the way it wouldn't log any changes? Anyway, some testing needs to be done now :)

Actually CACHE READS is exactly what I need for a current project, the incoming LOB feed is too high to have them logging, but the app can somewhat benefit from LOB caching in buffer cache. I relieved write performance problem by using OCI LOB caching and batch writes for incoming content feed (and the app is gonna run on a dedicated write-cache enabled Hitachi 9980V as well).

Thanks,
Tanel.

>
>
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
> Next public appearances:
> Jan 29th 2004 UKOUG Unix SIG - v$ and x$
> March 2004 Hotsos Symposium - The Burden of Proof
> March 2004 Charlotte NC OUG - CBO Tutorial
> April 2004 Iceland
>
>
> One-day tutorials:
> http://www.jlcomp.demon.co.uk/tutorial.html
>
>
> Three-day seminar:
> see http://www.jlcomp.demon.co.uk/seminar.html
> ____UK___February
> ____UK___June
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, January 30, 2004 12:19 AM
>
>
> > Jonathan,
> >
> > about which version are you talking here?
> >
> > > (You do also have the option in more recent versions
> > > of refining the caching properties so the LOB can be
> > > readcache only, writecache only or read/write cache
> > > or nocache, I believe).
> >
> > I haven't found a way to explicitly set read or write caching for LOBs
in
> > system level, although I've done some research on them lately (on 10g as
> > well). Or are you talking about OCI LOB caching here?
> >
> > Tanel.
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Lewis
> INET: jonathan_at_jlcomp.demon.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).