I too have been contemplating using locally managed tablespaces for a while. I am still undecided as to the benefits in the TEMP and RBS type tablespaces since those are already managed. However, I think it will help in the DATA type tablespaces. Since most OLTP systems have a variety of table sizes, I was thinking about having multiple locally managed tablespaces for my data segments; DATA_SMALL (1M), DATA_MEDIUM(64M), and DATA_LARGE (512M).

I know the CW is that the number of extents is irrelvent, but putting 120 Million rows into 64K extents just doesn't make sense to me.