I'm a geologist and I've worked for three of the majors. I've seen good work conditions and I've seen terrible. (This is all office-based work, too. Things are a _lot_ rougher in the field.)
Essentially all geologists are in the "upstream" side of things (i.e. finding oil/gas and getting it out of the ground). Upstream has three segments (exploration, development, and production), and the work-culture depends a lot on which one of those you're in.
At least in my experience, in exploration things are very schedule-driven. You work crazy hours all the time to meet arbitrary deadlines. Supposedly, we work a 9/80 schedule and get every other Friday off. No one is allowed to take those... It's 7-5 six days a week, and more when it's crunch time. Taking "vacation" means working from home or only coming in for half a day. We're required to code our vacation every year, but I've regularly seen people forced to work through 100% of their vacation time.
Development (oilfield development, not software) is typically a bit more paced. Most of the work will be on a very regular schedule, except for when you're responsible for a well that's being drilled. If you're sitting a well, you're on-call 24/7 for a few weeks. You will have lots of 10pm, 2am, and 6am conference calls and then go in and work a full day. However, you'll typically be told to not show up at the office for a week or so afterwards (that's always informal -- the majors all have strict no comp time rules).
The other segment of upstream is production. I've never worked production, so I can't comment there.
I'm currently in R&D (software development, actually), and it's much more relaxed. We have our own personal hell in terms of the amount of paperwork and meetings that are required to do _anything_, but the hours are more reasonable.
At any rate, the big companies are all effectively 20-50 semi-independent small companies, in my experience. The work culture between those small companies will vary wildly.
I'm not even talking about field jobs though. Analysts, developers and white collar workers inside Exxon are generally expected to put in massive hours.