6. Tuning Tools in TOAD

The Oracle database contains a variety of useful information when it comes to SQL and database performance monitoring and tuning. This chapter focuses on a variety of useful tuning topics that are integrated into TOAD.

Oracle Tuning Using TOAD

SQL explain plans provide useful information about how Oracle will process the SQL statement and perform the requested tasks. TOAD has several options for displaying these explain plans in useful formats. Auto trace is the ability to see the statistics from Oracle that the particular SQL statement generated when executing.

The Oracle Trace facility, also known as a 10046 SQL trace (pronounced 10-046), captures all SQL (both application code and SQL generated by Oracle) for either ...

Get TOAD now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.