G
Grant Holman
Guest
Hi Gus. Are you saying creating extents to based on RPBs is a pointless exercise? We are running on Windows with a 4K O/S block size (I think Windows actually calls this Cluster size?) and a 4K DB size (it's my understanding this is the most appropriate for Windows, please correct me if 8K would be better!). BI is 8K though. The point of the exercise is not to address 32 bit rowid limits - our DBs only have 10s of millions of records in total so 2.1 billion per extent is more than enough! However we have some tables with very small records (e.g. 30 bytes) and some larger (e.g. 3,500 bytes) - it seemed to me that putting these in appropriately RPB sized extents would make sense. Am I wasting my time? Should I just bunge everything into 32 RPB extents and not worry about it?
Continue reading...
Continue reading...