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,
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
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