It's your basic multiple-step process:

1. Initial phone screen with a recruiter.
2. Phone screen with the hiring manager/director.
3. Full-day interview loop with 5-6 people, including behavioral analysis, system design, management style, and job description chops.

Oracle is a big company; be prepared to wait weeks from the initial phone screen to the offer process, should you make it.

1. Tell me about a time you were working on a project you knew was going to fail and what you did about it.

2. Tell me about your favorite product or feature you've worked on and why.

3. Tell me about a time when a team member wasn't meeting expectations and how you handled it.

4. Let's design a Tiny URL system.