ASM Storage Waste issue
We have an HP-UX environment with an XP24000 storage array on which we have configured Oracle 11gR1 ASM storage. We have implemented 8 MB Allocation Unit (AU_SIZE) for the data and flash diskgroups. On our FLASH diskgroup we have noticed severe storage waste for flash logs where, for example, 64 MB would be allocated for a flash log but sometimes less than 8 MB used out of it. We're wondering if using a smaller AU_SIZE for flash will help (1 MB or less) and are interested in what other implementations use for their AU_SIZE. Below are some figures.
.
The bottom line is for flash logs, out of 2.39 TB allocated overall to flash logs, only 1.53 TB is actually in use, wasting 0.86 TB which we could really use..
0