A report that shows how Oracle plans to execute a given SQL query to retrieve the requested data. Commonly used by developers and DBA's to diagnose poorly performing SQL queries. For example, check if the query is doing a quick lookup or a lengthy full table scan. Also see Execution Plan and Plan Table.