ASM Allocation Unit vs Tablespace Uniform Extents
fuzzydbaSep 19 2010 — edited Sep 19 2010Hi All,
I am doing a proof of concept on migrating our file-system based databases to ASM and RAC. The current database has tablespaces with Uniform Extent Management of extent sizes 10M, 100M and 512M.
In ASM, i see from the Oracle Documentaion that ASM allocates extents based on AU's starting from 1MB. After the first 20000 extent sets, the extent size becomes 8*AU for next 20000 extent sets. The next increment for an ASM extent is 64*AU.
[http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmcon.htm#BABCGDBF]
So my question is that how can i have tablespaces with uniform extent size of say 100M on ASM? If so, will ASM further breakdown the extent sizes to its default AU size?
Appreciate responses on this one!!!
Regards,
Naren