Pros
It's a huge company, generally there's a lot of runway for projects/initiatives so less work pressure. Oracle has offerings across pretty much the entire IT stack, this means an entire solution can be offered to customers.
Cons
Lots of politics, if you're not visible 1-2 (sales) tiers above your direct manager, your career will stagnate. You are pretty much tied to whatever compensation you can negotiate coming in, because annual increases are nonexistent to minimal. The only sure-fire way to get a decent increment is by showing your manager a competing offer. If your manager wants to retain you, Oracle will counter-offer. I experienced this, the counter-offer was in fact better than the competing offer, but I felt that I had to decline. It pretty much sucks that long-term employees (I was there 9 years) suffer compensation-wise and need to resort to seeking outside offers, while new hires come in at significantly higher levels (since the median acquisition cost increases every year) but I understand this is common in the industry.