CONS:
First of all the balance personal life/work is 0 (because 0 divided by anything is 0 :). Theoretically I was paid for 39 hours but adding the extra hours and travelling I went on normal bases to 60-70 hours of work per week. However the weekends and 4 weeks of vacation were mine (I never worked 1 weekend in 4 years). This can be OK if you don't have a family, but if you have one and you don't want to divorce, sooner or later you will end up by searching something else. I can mention that the 75% of my colleagues are singles (without a serious very long-term relationship).
Never expect a promotion or a salary growth. If however you succeed to be promoted after years your manager will explain you how appreciated you are in the company, but that the situation is bad (either if the shares are going up on market) and that the promotion will not be noticeable in salary. But this is what it's happening in other big companies as well, so the new strategy I see is: stay 3-5 years with a company, then get a "promotion" in other company for 3-4 years and then come back again to Oracle to be "promoted" to a job that you would not reach inside in 20 years.
Never expect a financial recognition for your exceptional work.
Better get used that you don't get the end of year bonus (if this is related somehow with the performances of the company and not a commission of your work... so I don't speak here about a sales bonus for example). If you get it you have why to be happy, but 3 out of 4 years you will not get it.
Never expect to apply internally to find another job in Oracle (especially cross-countries).