Pros
There is a belief that Oracle is a legacy software vendor but this is far from true. There is tremendous vision here, as well as execution. Oracle is positioned exceptionally well for the next decade in multiple verticals with multiple products. The pay is very good - yes it isn't at the level of AWS, but the work culture is far better here at Oracle. There is a reason that the stock price has been exploding. I'm very excited to see how Oracle products evolve in the next 2-3 years.
Cons
The usual drawbacks of working for a huge company. Few promotions and raises, but Oracle is so big you can make up for this with lateral moves. I would advise you to join a growing team rather than a legacy product team if possible - there are many. If you find one, it will be an exciting journey for you at Oracle.