Re: [Q] wait time /lob def

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Thu, 29 Jan 2004 09:04:25 -0800
Message-ID: <F001.005DE5E5.20040129090425@fatcity.com>

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 <tanel.poder.003_at_mail.ee> 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: 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).
  

  ---

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: barbarabbaker_at_yahoo.com

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).

Received on Thu Jan 29 2004 - 11:04:25 CST