You are previewing TOAD® Handbook.
O'Reilly logo
TOAD® Handbook

Book Description

TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.

Table of Contents

  1. Copyright
  2. About the Authors
  3. Acknowledgments
  4. We Want to Hear from You!
  5. Foreword (by the Toadman)
  6. Introduction
  7. Setting Up TOAD for Successful Use
    1. Meeting TOAD’s Database Connectivity Needs
    2. Understanding TOAD’s Oracle-Based Security
    3. Creating the All-Important TOAD Schema
    4. Activating TOAD’s “Read-Only” Mode
    5. Using TOAD’s New Advanced Security
    6. Enabling TOAD’s PL/SQL Profiler Support
    7. Saving and Restoring All Your TOAD Settings
    8. Summary
  8. Using TOAD’s Schema Browser
    1. Making Schema Browser Your Startup Screen
    2. Choosing Among Schema Browser Display Styles
    3. Enabling or Disabling Schema Browser Tabs
    4. Configuring Schema Browser Tabs
    5. Filtering Schema Browser Schemas
    6. Filtering Schema Browser Objects
    7. Filtering and Sorting Schema Browser Data
    8. Using Favorites as a Custom Schema Browser
    9. Setting Some Advanced Schema Browser Options
    10. Summary
  9. TOAD SQL Editor
    1. Overview
    2. Predefined Shortcuts
    3. User-Defined Shortcuts
    4. Using Variables
    5. Table and Column Name Select Lists
    6. Using Aliases and Autoreplacement Substitutions
    7. SQL Templates
    8. Code Completion Templates
    9. Executing SQL Statements
    10. Executing SQL Scripts
    11. Editing Result-Set Data
    12. Saving Result-Set Data
    13. Printing Result-Set Data
    14. Examining Explain Plans
    15. Examining Basic Performance Info
    16. Using Auto Trace
    17. SQL*Plus Compatibility
    18. Scripts That Write Scripts
    19. Summary
  10. TOAD Procedure Editor
    1. Overview
    2. Predefined Shortcuts
    3. User-Defined Shortcuts
    4. Using Variables
    5. Table and Column Name Select Lists
    6. Using Aliases and Auto Replacement Substitutions
    7. SQL Templates
    8. PL/SQL Object Templates
    9. Creating a New PL/SQL Object
    10. Using the PL/SQL Navigator
    11. Compiling PL/SQL Code
    12. Executing PL/SQL Code
    13. Saving PL/SQL Code to Files
    14. Formatting PL/SQL Code
    15. Using DBMS_OUTPUT
    16. Debugging Setup, Requirements, and Parameters
    17. Basic Debugging PL/SQL Code
    18. Debugging Breakpoint Options
    19. Advanced Debugging PL/SQL Code
    20. Profiling PL/SQL Code
    21. Setting Up Source Control
    22. Using Source Control
    23. Summary
  11. Using TOAD for Routine DBA Tasks
    1. Checking Status of All Your Instances
    2. Checking an Instance’s Alert Log File
    3. Examining Tablespace Usage and Projections
    4. Checking Tablespaces for Free Space Deficits
    5. Reviewing Schema Object Extent Allocations
    6. Checking the Level of Tablespace Fragmentation
    7. Checking the Overall Health of a Database
    8. Monitoring SQL Currently in the Shared Pool
    9. Determining Resource-Intensive Sessions
    10. Monitoring and Killing User Sessions
    11. Creating, Altering, and Managing Database Objects
    12. Scheduling DBA Tasks by Using UNIX Job Scheduler
    13. Summary
  12. Using TOAD for Non-Routine DBA Tasks
    1. Creating a New Database
    2. Starting and Stopping Databases
    3. Examining Oracle and NLS Parameters
    4. Estimating Table and Index Sizes
    5. Analyzing Tables and Indexes
    6. Rebuilding a Table
    7. Rebuilding Multiple Indexes
    8. Repairing Tables with Chained Rows
    9. Pinning PL/SQL Code in the SGA
    10. Generating Schema Scripts
    11. Comparing Schema Differences
    12. Monitoring a Database Instance
    13. Examining Server Statistics
    14. Examining Control Files
    15. Managing Redo Log Files
    16. Examining Redo Log File Switches
    17. Mining Redo Log Files
    18. Monitoring a UNIX Server
    19. Tuning the UNIX Kernel
    20. Tuning the Windows Registry
    21. Summary
  13. Generating Database Reports via TOAD
    1. Running Standard Database Reports
    2. Creating HTML Schema Doc Generator Reports
    3. Running DBA Scripts to Create Reports
    4. Summary
  14. Exporting Table Data
    1. Overview
    2. Formatting Data for Reporting/Non-Oracle Data Loads
    3. Formatting Data as INSERT Statements
    4. Formatting Multiple Table Data as INSERT Statements
    5. Using the Export Utility Wizard
    6. Summary
  15. Using Other Powerful TOAD Tools
    1. Browsing Master-Detail Data
    2. Modeling Complex SQL Visually
    3. Generating Entity Relationship Diagrams
    4. Registering External Programs
    5. Comparing Files for Differences
    6. Using FTP and Network Utilities
    7. Editing Oracle TNS Name Files
    8. Tracing Execution Using TKPROF
    9. Subsetting Production Data
    10. Managing SQL Scripts Made Easy
    11. Summary
  16. Knowing the TOAD World and Its Add-ons
    1. Knowing the World According to TOAD
    2. Using Formatter Plus for PL/SQL
    3. Using the Knowledge Xpert Products
    4. Using SQLab Xpert Tuning
    5. Using Benchmark Factory
    6. Using QDesigner
    7. Summary
  17. Index