As part of the #ThanksOTN idea on Twitter, my favourite Oracle feature is the ability to easily view and analyse execution plans for queries.
Time and time again I’ve needed to see how a query is running, and Oracle databases make it easy to view the execution plan.
You can view it in either a text format or a table format (at least in SQL Developer), and it’s even available with a keyboard shortcut.
It’s really helped me to make it easier improve my queries.
For the Oracle community’s favourite features, search for the #ThanksOTN tag on Twitter. I believe Tim from www.oracle-base.com is putting together a list.