O'Reilly logo

TOAD by Dan Hotka, Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required