Oracle DB is the "do everything database", it has nearly every DB paradigm "all-in-one", and is an extremely well-tested and predictable product. It often comes bundled with entire vertical solutions like "Bank in a Box" or "CRM", and with a contract including SLAs, so you're covered if/when things go wrong (as long as you pay $$$).
There are a lot of pros and cons, too many to enumerate on a Thursday night before dinner.
Bottom line: Oracle DB can be super expensive, but if you pay [enough] then Oracle will give you endless support to ensure you are successful (so you can keep paying them). They have some top-notch in-house expertise and there are good reasons large businesses keep paying the bill and renewing contracts (some part lock-in, other part solving real business needs).
Personally, I really like Postgres and SQLite. But they're no Bank-in-Box, and the support is comprised of "https://google.com/?q=...".
The reason Oracle makes so much money is not because they are best for some definition of best, but:
1. Lock in -> A database change is hard to do even for extremely focused tech companies. For companies whose core business is not technology, it might not even make sense to bother.
2. They expanded beyond the DB to acquire several companies like Peoplesoft and Netsuite and companies needing these inevitably turn to Oracle database.
Don't get me wrong, oracle has tons of Optimisations packed into it, but there is nothing which makes it the best database, or even an unambiguous top 3 databse product.
https://www.dbmaestro.com/blog/database-automation/postgresq...
Perhaps 25 years ago it was true.
Fixing Oracle bugs, it's like a knightmare.