The BLOB can be "in line" if the size is less than 4k, otherwise it is stored as "out-of-line".
RWB "Gene Sais" <[EMAIL PROTECTED]>@fatcity.com on 10/29/2002 07:39:01 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: I have a 1tb db w/ 95% of it inline blobs, same tbs as data. No performance degradation. However, if I were to do it again, I would have separated the blobs out as B/R is a nightmare, soon to be better w/ RMAN. I haven't received my RF RMAN book yet, amazon must be backfilling orders. hth, Gene >>> [EMAIL PROTECTED] 10/28/02 09:18PM >>> We've got a table with a BLOB column that is currently at 3+ Gig (400,000 records). The max value in the BLOB column is 3k (average (1.5 K). We are currently storing the BLOB "out of line" (in a separate tablespace). The cache size for the BLOB is 8k (also the block size). Each BLOB is taking up 8K (at the least twice the space required by the BLOB). This table is expected to grow to 10+ million records in the next year. First of all, we're trying to convince the vendor to agree to partition the table. In addition (FINALLY the question :-) !!!), we're trying to decide whether we would gain anything (space being a constraint right now), from a storage standpoint in making the BLOB "in line". Obviously we're not going to going to risk performance in order to save space :-) !!! I'm hoping someone in this list would have had some goog or bad experience in this regard. Would there be a major performance hit if I change the BLOB to be "in line" ???? Thanks, Sunny --------------------------------- Do you Yahoo!? Y! Web Hosting - Let the expert host your web site -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
