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