Oracle is the choice if you need a high performance RDBMS capable of processing extreme amounts of data at extreme io rates. Nothing comes close for enterprise level applications. THAT SAID, it requires a special kind of individual to be able to get the most out of it. Even better if that person knows of the existence, value, and use of the many undocumented v$ tables, etc.
Once you can migrate most of your data out of an RDBMS, you options open up significantly.
For smaller projects. Oracle makes no sense, unless the expectation is vast and rapid growth.
EDIT: Oracle is the most evil corporation in tech. Those who know, know.