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

Home -> Community -> Mailing Lists -> Oracle-L -> LOB caching

LOB caching

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Tue, 20 Jun 2000 20:30:12 +0300
Message-Id: <10534.109880@fatcity.com>


Hello,

Could someone give me advice about using LOB caching (ALTER TABLE xxx MODIFY LOB (yyy) (CACHE))?

Would it be the right choice to use LOB caching for an application that retrieves lots of images from BLOB column (so that Oracle won't always put them at the very end of the LRU list in buffer cache)

thanx,

    Marin


"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"
Received on Tue Jun 20 2000 - 12:30:12 CDT

Original text of this message

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