Pros
This is the place where tomorrow's technology gets made - especially now that Oracle owns Java via Sun Microsystems aquisition. The possibilities are infinite; ample opportunity for growth. There is a high degree of freedom in what you can do. I am currently a technical consultant; if I wanted to move to sales / pre-sales OR to product engineering, management would support the move. Great place to work for self motivated people.
Cons
Sometimes work pressure can be high implacting work-life balance. The salary that you join at is often the salary at which you quit 4 years later - after being annoyed that you did not get a slary raise in 4 years. So, if an Oracle recruiter tells you that you can get a good raise the next year, take it with a pinch of salt. If you quiz the management about the salary and bonus, the standard answer is "it is not in our hands". Apparently all salary/bonus decisions rest with the absoute top management sitting in Oracle HQ (Redwood Shores, CA, USA) - which means it is quite frustrating.