Oracle plan-Access path ranking

This blog post is more as mine public memo...to remind me on some details that I from time to time forget. 

Hope this helps someone.

Cheers!