tag:blogger.com,1999:blog-2170637149389736039.post8960660009534862956..comments2023-10-30T06:20:46.020-07:00Comments on Simple Oracle Dba: multible blocksizes in an Oracle DatabasePdVhttp://www.blogger.com/profile/11518325134965208858noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2170637149389736039.post-22240126343311955712010-03-29T10:55:33.963-07:002010-03-29T10:55:33.963-07:00Hi Colin, long time not seen.
You are correct, a...Hi Colin, long time not seen. <br /><br />You are correct, and I also remember that: the original reason to have multiple blocksizes was to allow TTS with other blocksizes to be plugged into a database.<br /><br />however, you cannot stop an engineer from tinkering with a feature for whatever purpose he can think of. And the Multiple blocksize feature _could_ potentially be used/abused to control cache-behaviour. Not to mention the supposed benefit of having indexes in XL blocks.<br /><br />All good fun to try.<br />But in the end, simplicity is most often the best option.PdVhttps://www.blogger.com/profile/11518325134965208858noreply@blogger.comtag:blogger.com,1999:blog-2170637149389736039.post-50407419186516510512010-03-29T06:48:09.265-07:002010-03-29T06:48:09.265-07:00I always thought the only reason to have multiple ...I always thought the only reason to have multiple blocksizes was to support transporting tablespaces between instances with differing default block sizes?Colin 't Harthttps://www.blogger.com/profile/15623835285718803326noreply@blogger.com