Pros
About the best thing you can say for Oracle is that it's a big company with deep pockets. It will definitely be around in 10 years and it's throwing a ton of money at being successful in the Cloud. The work environment is very collegial. I'd say it's a good place if you're a Sr. Director or above.
Cons
There are alot of cons. Primarily, it's a top down organization with SVPs making the most minute, and often poor, decisions on product features and direction. It's first and foremost an engineering company, as opposed to a market-driven firm, which is a double-edged sword since there are many "boil-the-ocean" projects with are un-sellable and un-implementable. Fusion Apps, despite what they say, has been an egregious management failure (if it was so great, why did Oracle purchase RightNow, Taleo, and Netsuite? - and why does Oracle trail Salesforce and Workday so badly?). Many of the solutions require other Oracle products, which prevents individual groups from achieving their own optimal products (e.g., groups are required to use Oracle's IdM and OBIEE product - which are disasters).