Awesome post by Kevin! Recommended read if you are interested in Oracle Exadata.
An IT infrastructure perspective on optimizing business applications
Archiving and purging old data In the end, if you want to seriously reduce the effective size of a database (after using all innovations on the infrastructure level) is to move data out of the database on to something else.…
Database compression Another technique that Oracle has improved as of version 11g is compression. In versions up to 10g you could only compress an entire table, and after that, random performance on a compressed table was poor. It…