3 round-2 technical, 1 Managerial (All were approx 1 hr and above).
First round- Starts from basic then gradually moved to advance level plsql questions (index, tuning, procedure, exception handling, cursors, hierarchical query, etc). More focused on clarity of concepts rather than syntax.
2nd round after 5 days- Similar to first round also, asked the question which I was not able to answer in first round. some basic SQL query to write, given a situation to write a procedure.
Managerial: Asked about project, then few situational and technical question followed by salary expectation, etc.