Last week I had to help a collegue with the Oracle adapter. To get started I used the following 2 articles:
Wilfried Mausz’s Oracle adapter demo
These two articles and some general BizTalk knowledge helped me to understand most of the Oracle adapter in very little time.
Sharing knowledge rocks! Thanks guys!