Pros
Oracle is a large company with lots of opportunities. The stock has done well since Oracle is a cheaper investment into cloud compared to Amazon, Microsoft. Some products and business units are a pleasure to work with, especially former acquisitions.
Cons
Your experience will vary widely depending on what business unit you are in and what product you're aligned to. The wrong business unit and senior management and your time will be miserable. Find the right fit and it can be a very rewarding and fulfilling period of your career. Compensation is ok but not as competitive as Oracle's counterparts in the tech world. They'll swear up and down that they pay competitive rates in the market but the reality is compensation increases will be much faster if you go somewhere else or leave and come back, especially if you aren't given RSUs as part of your compensation.