Re: Tuning direct path read (lob)

>
> It sounds as if you have some lobs declared
> to be out of line and nocache.  Depending on
> the way you are using the lobs it may help if
> you cache them.  However, since lobs are
> "large" objects, this could cause havoc in your
> cache so you may want create a relatively small
> recycle pool and assign the lobs to it.  This gives
> you the benefit of cached lobs without the threat
> of flooding your main cache with lob data and
> kicking everything else out.
>
> --
> Regards
>
> Jonathan Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html

I checked the application schema and all lobs are created with CACHE=NO and IN_ROW=YES.
Some of them have LOGGING turned on, some not. I also noticed that the version of 8i is 8.1.7.0.0, so without any patch set installed. I will contact the application vendor to see if they have an update or if I can upgrade myself.

Matthias Received on Fri Mar 20 2009 - 03:25:44 CDT