Pros
Oracle is well-known throughout the software industry and builds enterprise software used by pretty much every major company you've ever heard of. As such, it's a great resume builder. Oracle is also multi-national and you get some great experience learning how a large software company works when so many people work somewhere else other than your building. The company is also good at promoting minorities and encouraging modern ideals.
Kontras
Oracle is still a good old boy network still run by database-centric people and many of them are poor managers. For all the companies they have acquired, there is not much new blood running the company. Acquired company management can abandon most hopes at Oracle unless you have connections. Also, no matter what your position, watch your back because someone is always looking to stab it.