uniform size and autoallocate of extent in a tablespace
Hi,
We are using high-performance spinning disk in RAID 10 , instead of SSD technology. We have different tablespace setup with uniform size of 128k, 4m and 128m with total size of 2TB.
our database is OLTP
1) In terms of performance, is uniform size or autoallocate extent recommended in 11g and 12c ?
2) How do we determine if we have apply with the correct uniform size ?
3) my understanding is locally managed tablespace does not has to worry about fragmentation anymore, so does it make any different if we are using uniform or autoallocate in terms of performance ?
Thank you.