Oracle : Key Tables

This lists some of the tables that are of good use when looking at data at the session level.


1. v$session_longops: Has data regarding operations that are running on the database.

Execution plan on SQLPLUS

To get only the execution plan for a query and check for its performance even before executing the query, use the foll command on sqlplus:

set autotrace traceonly explain

This will show the execution plan for the query.