I applied through college or university. The process took 1 day. I interviewed at Oracle (San Francisco, CA) in Nov 2008
Interview
Was contacted directly via email that Oracle wanted to interview me on-site. They claimed they found my CV through the school's database. They were very generous and hospitable throughout the stay: they flew me in on a Wednesday evening, had a rental car waiting, and put me to sleep in a nice hotel. Thursday was interviews all day long, one after the other (6 total, each about 1 - 1.5 hours long). Many consisted of IQ questions (puzzle solving), but there were also personality tests and skills tests. Specifically, they grilled me on Java knowledge (keywords, syntax, and example problems). The interviews were all independent of each other: each interview was really a smaller group within Oracle that wanted to interview me their own way. They let me stay in SF all of Friday, and I flew home on Saturday morning.
5 horses on a 5-lane track. You have 5 horses and you want to rank the top three. All you have available to you is a track and the ability to tell perfectly in which order the horses crossed the finish line. How many races are necessary in order to rank the top three horses?
I applied in-person. The process took 1 day. I interviewed at Oracle (Hyderābād) in Apr 2010
Interview
It was basically a very good experience.
There were 4 rounds of interview.
2 Technical and 2 Managerial level which were also sort of technical + HR.
In the first two rounds they asked about java, j2ee. Also they asked some puzzles.
So prepare well for java. They are checking your basics.
I applied through college or university. The process took 1 day. I interviewed at Oracle in Oct 2008
Interview
The interview started with behavioral questions. After that the interviewer asked me questions about my resume, what all I had done in the university i.e. academic projects. For the technical part the questions were mostly related to unix and PL/SQL. Also I was asked basic Java questions such as garbage collection, access speccifier etc. Only the unix part was difficult rest of the interview was average.