More on Oracle execution plans

Another useful command in looking at Oracle execution plans is:

set autotrace traceonly explain

Query plans in Oracle (EXPLAIN PLAN)

Discovered this article when looking up how to view a query plan in Oracle.

How to determine owners of Oracle tables

I recently needed to find out the schema names of certain Oracle tables that belonged to schemas other than the connecting user. This is because the four-part queries in SQL Server require the schema/owner name of the tables referenced. This query (run in SQL*Plus) lists the owners and names of all tables that can be seen by the connecting user:

SELECT OWNER, TABLE_NAME FROM ALL_TABLES;

A full reference for the ALL_TABLES view can be found here.