Jonathan / Tanel:
I, however, AM having this problem. Didn't know where
to look till I saw this message. (I love this list!)
I've yet to capture the sid (and therefore track back
to the table) where the 'direct path write' occurs.
Definitions for the tables were supplied by the
vendor. When I look at at the lobs, the definitions
are mixed. Most are nocache, logging yes. some are
no/no
I don't see much on metalink about this -- just a
couple of generic articles on lob storage.
Should I change the lobs to cache/logging across the
board?
Thanks for any insight.
Barb
Table
Name Cach LOG
---------------- ---- ---
CONTACTGROUP NO YES
CONTENT NO YES
IMAGEBINARY NO YES
IMAGEHEADER NO YES
IMAGEROW NO NO
IMPORTIN NO NO
TF_NEW_CONTENT NO YES
XMLS_DICTIONARY NO YES
XMLS_SALESSUPPORT NO NO
XMLS_STYLEPART YES YES
--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
>
> > Do you have any LOBs defined with
> > the nocache nologging attribute ?
>
> This was what I initially thought would be the
> problem, but then I thought,
> in case of nocache lobs you should see direct path
> writes (lob) a lot...
>
> Tanel.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
