This content has been marked as final. Show 6 replies
The usable storage for Exadata is calculated after factoring in ASM redundancy and after reserving some free space to tolerate disk failures.
The usable storage is the space available for the DBFS, DATA, and RECO disk groups and is not necessarily a reflection of how much user data can be stored.
The actual amount of user data that can stored in a rack will vary based on whether compression is used, the amount of indexes created, the size of temp and undo tablespaces, the amount of space reserved for archive logs, the space reserved for on-disk backups, etc.
Hope it helps...
We are using single mirror (normal, i believe), and I think I can figure out the size of RECO...
in SYS@+ASM1>, can I run commands to find out how much assinged space, how much free, and how much being used?
what about any cellcli commands?
Edited by: 943714 on Mar 27, 2013 11:33 AM
You're actually better off looking in ASM - v$asm_diskgroup especially.
That has total size, total used, total free, required_mirror size and safely usable size of each diskgroup.
Figure out which disks you purchased too.
I use this sql statement on a database to give me info on available and used space on my exadata cells.
select name,Try it and let us know if this is what you are looking for.
where total_mb != 0