Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

CHAPTER 6: Execution Plans > Obtaining Execution Plans

Obtaining Execution Plans

Basically, Oracle provides four methods to obtain an execution plan:

  • Execute the SQL statement EXPLAIN PLAN, and then query the table where the output was written.
  • Query a dynamic performance view showing the execution plans cached in the library cache.
  • Query an Automatic Workload Repository or Statspack table, showing the execution plans stored in the repository.
  • Activate a tracing facility providing execution plans.

No other methods exist. Since all tools displaying execution plans take advantage of one of these methods, the following sections will describe just the basics, instead of focusing on specific tools such as Oracle Enterprise Manager or Quest TOAD. I won't discuss such tools here also because, more often than not, they do not provide all the information you need for a thorough analysis.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint