Pros
Market leadership, for one; Oracle continues to succeed where others have failed. Being the largest enterprise software vendor there are numerous opportunities for advancement and transfer within and between lines of business. A stunning campus and super-charged atmosphere of brains and motivation make for an unparalleled work environment. Nearly every job is self-starting, in that you are expected to innovate every day, and bring more value to the team, organization, and company as a whole. Oracle's cafeterias are award-winning as well, and as an employee you are on the inside of a market-defining company every day - hard to beat!
Cons
Large companies tend to lose track of individuals unless they promote themselves aggressively. And of course there is fierce competition for finite resources such as bonus and stock pools, title advancement, and recognition awards. Making it to "Sales Club" as a Sales Consultant is next to impossible, given that very few slots are awarded outside those who carry actual quotas. Benefits and perks have been scaling back ever so gradually over the past few years for SCs; travel has been scaled back, cubicle hotelling has swept the organization, and so forth, while management strives to wring every ounce of productivity out of the Sales organization.