While browsing through BCS documentation came across this section on how to design models for connecting to Oracle. What is the support in tools to design and how to do it. Hope you will find it useful

http://msdn.microsoft.com/en-us/library/ff464424(office.14).aspx