I applied through college or university. The process took 2 days. I interviewed at Oracle in Jan 2011
Interview
Each department has their own style of interview. Most departments spent most of the time explaining what the department does and the organization. There were very few personal questions.
The former Sun departments were much different. In those, I was asked technical questions, as well as questions about my background. For example, the Solaris team asked many questions about C, operating systems, and relevant mathematics.
I applied through college or university. The process took 1 week. I interviewed at Oracle (Redwood City, CA) in Nov 2011
Interview
Was emailed by the recruiter for an onsite invitation without any phone interviews.
Was told to pick from a set of short listed groups, mostly revolving around databases. Groups were selected by the recruiter from what they think matches my resume best. Some of the groups selected weren't really what I was interested in.
Out of the groups I selected I only met with 1 group, the recruiter added 2 more groups which I did not select to my set of interviews for the onsite.
Only did 3 interviews for my onsite, few technical questions. Interviewers were generally friendly and comfortable to talk to.