Pros
If you're employed in the states your pay will be high not so much in the rest of the world but you will get good benefits, flexible working depending on your manager, team and responsibilities. f you are a designer Oracle is behind many other companies in term of the design of its current products which means there is a lot of scope to improve them and currently a huge push to use and improve their new design system for all existing and future applications. For someone who is ambitious and looking for experience in large MNO Oracle is good. You can get good benefits if you perform well and share packages are available. Training opportunities are pretty good overall.
Cons
If you move laterally and get a pay rise in the move you won't get a pay rise for two years. Its hard to get above average pay rises and progress up the ranks can be slow within the team however lateral moves are possible and you can leave and return to the company up to two times which is nice. Management can be a bit too political but again like any company that depends on the team and the individuals you happen to be working with or for.