Explain Plan in Oracle DB

There are many factors affecting the performance of a SQL operation. Consider a database which has millions of records. An ordinary select query passed with multiple joins and filtration may take a serious amount of time in retrieving the results. So it is essential for any programmer to understand how the query works, its execution steps and if the query is taking more than usual time to fetch, then under what conditions the query is slow and so on.