share and learn

Chapter 1. Setting Up TOAD for Successful Use

• Meeting TOAD's Database Connectivity Needs
• Understanding TOAD's Oracle-Based Security
• Creating the All-Important TOAD Schema
• Activating TOAD's "Read-Only" Mode
• Using TOAD's New Advanced Security
• Enabling TOAD's PL/SQL Profiler Support
• Saving and Restoring All Your TOAD Settings
• Summary

Chapter 2. Using TOAD's Schema Browser

• Making Schema Browser Your Startup Screen
• Choosing Among Schema Browser Display Styles
• Enabling or Disabling Schema Browser Tabs
• Configuring Schema Browser Tabs
• Filtering Schema Browser Schemas
• Filtering Schema Browser Objects
• Filtering and Sorting Schema Browser Data
• Using Favorites as a Custom Schema Browser
• Setting Some Advanced Schema Browser Options
• Summary

Chapter 3. TOAD SQL Editor

• Overview
• Predefined Shortcuts
• User-Defined Shortcuts
• Using Variables
• Table and Column Name Select Lists
• Using Aliases and Autoreplacement Substitutions
• SQL Templates
• Code Completion Templates
• Executing SQL Statements
• Executing SQL Scripts
• Editing Result-Set Data
• Saving Result-Set Data
• Printing Result-Set Data
• Examining Explain Plans
• Examining Basic Performance Info
• Using Auto Trace
• SQL*Plus Compatibility
• Scripts That Write Scripts
• Summary

Chapter 4. TOAD Procedure Editor

• Overview
• Predefined Shortcuts
• User-Defined Shortcuts
• Using Variables
• Table and Column Name Select Lists
• Using Aliases and Auto Replacement Substitutions
• SQL Templates
• PL/SQL Object Templates
• Creating a New PL/SQL Object
• Using the PL/SQL Navigator
• Compiling PL/SQL Code
• Executing PL/SQL Code
• Saving PL/SQL Code to Files
• Formatting PL/SQL Code
• Using DBMS_OUTPUT
• Debugging Setup, Requirements, and Parameters
• Basic Debugging PL/SQL Code
• Debugging Breakpoint Options
• Advanced Debugging PL/SQL Code
• Profiling PL/SQL Code
• Setting Up Source Control
• Using Source Control
• Summary

Chapter 5. Using TOAD for Routine DBA Tasks

• Checking Status of All Your Instances
• Checking an Instance's Alert Log File
• Examining Tablespace Usage and Projections
• Checking Tablespaces for Free Space Deficits
• Reviewing Schema Object Extent Allocations
• Checking the Level of Tablespace Fragmentation
• Checking the Overall Health of a Database
• Monitoring SQL Currently in the Shared Pool
• Determining Resource-Intensive Sessions
• Monitoring and Killing User Sessions
• Creating, Altering, and Managing Database Objects
• Scheduling DBA Tasks by Using UNIX Job Scheduler
• Summary