I recently completed Oracle Exadata training and learned about features like smart scans, storage indexes, and hybrid columnar compression. Could someone please explain in detail:

How these features translate into real-world performance improvements compared to a standard Oracle database running on traditional hardware?

What are the ideal workloads or scenarios where Exadata shows the most significant benefits?

Are there any common pitfalls or considerations when migrating existing databases to Exadata?

I’d appreciate examples or best practices from DBAs who have hands-on experience with Exadata.

Thank you!