Learn Oracle autotrace functions

Rather than using the cumbersome "explain plan" syntax to display a SQL execution plan, Oracle has the autotrace SQL*Plus utility to make it easy to see SQL execution plans. I have a several hundred pages on SQL tracing in my book "Oracle Tuning: The Definitive Reference".


The SQL*Plus autotrace command has these options:

Click below for more details on using autotrace with Oracle SQL:


I also have excellent tips for understanding Oracle trace files here:



Is your Database Healthy?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

BC has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.


Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog: