Question: how many days it will take to get offer letter from oracle?
Answer: In Oracle process takes multiple approvals from different levels and generally takes 2–3 months or even more time to release the offer letter. In your case it is already passed more than 6 months so I suggest you can directly check with your hiring manager(mail or call)about the position and offer letter.