Hmmn, mutation in digital storage. Maybe that's why programs seem to have a shelf life?
O> So if you have a very busy varchar2(1) column and a 16K db_block_size, a 16K O> block is written even if only one character in the block has changed? Seems O> like hotspots, er, hot blocks could do a "multiplicity" thing. You know... O> like the more you replicate DNA the more chance for mutation? :-) O> Been watching too many movies... R> The WAFL does indeed write to the nearest available inode and relinks R> the inode map. The unlinked inode is immediately available for R> rewrite unless it is a member of a snapshot. Thus while reserving R> unlinked blocks is inefficient from a storage perspective, it is a R> factor you get to control by controlling the snapshots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).