Hi After a clean database load a database would (should?) look like this, if a random stab at the data is taken...
[8KB-m][8KB-n][8KB-o][8KB-p]... The data should be fairly (100%) sequential in layout ... after some days though that same spot (using ZFS) would problably look like: [8KB-m][ ][8KB-o][ ] Is this "pseudo logical-physical" view correct (if blocks n and p was updated and with COW relocated somewhere else)? Could a utility be constructed to show the level of "fragmentation" ? (50% in above example) IF the above theory is flawed... how would fragmentation "look/be observed/calculated" under ZFS with large Oracle tablespaces? Does it even matter what the "fragmentation" is from a performance perspective? _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss