Table of content

	Table of Contents
	Index

TOAD Handbook
By Bert Scalzo, Dan Hotka
Publisher	: Sams Publishing
Pub Date	: February 21, 2003
ISBN	: 0-672-32486-5
Pages	: 312

		Copyright
		About the Authors
		Acknowledgments
		We Want to Hear from You!
		Foreword (by the Toadman)
		Introduction
			Approach of This Book
			How This Book Is Organized
			Conventions Used in This Book
			Source Code and Updates
		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
		Chapter 6.  Using TOAD for Non-Routine DBA Tasks
			Creating a New Database
			Starting and Stopping Databases
			Examining Oracle and NLS Parameters
			Estimating Table and Index Sizes
			Analyzing Tables and Indexes
			Rebuilding a Table
			Rebuilding Multiple Indexes
			Repairing Tables with Chained Rows
			Pinning PL/SQL Code in the SGA
			Generating Schema Scripts
			Comparing Schema Differences
			Monitoring a Database Instance
			Examining Server Statistics
			Examining Control Files
			Managing Redo Log Files
			Examining Redo Log File Switches
			Mining Redo Log Files
			Monitoring a UNIX Server
			Tuning the UNIX Kernel
			Tuning the Windows Registry
			Summary
		Chapter 7.  Generating Database Reports via TOAD
			Running Standard Database Reports
			Creating HTML Schema Doc Generator Reports
			Running DBA Scripts to Create Reports
			Summary
		Chapter 8.  Exporting Table Data
			Overview
			Formatting Data for Reporting/Non-Oracle Data Loads
			Formatting Data as INSERT Statements
			Formatting Multiple Table Data as INSERT Statements
			Using the Export Utility Wizard
			Summary
		Chapter 9.  Using Other Powerful TOAD Tools
			Browsing Master-Detail Data
			Modeling Complex SQL Visually
			Generating Entity Relationship Diagrams
			Registering External Programs
			Comparing Files for Differences
			Using FTP and Network Utilities
			Editing Oracle TNS Name Files
			Tracing Execution Using TKPROF
			Subsetting Production Data
			Managing SQL Scripts Made Easy
			Summary
		Chapter 10.  Knowing the TOAD World and Its Add-ons
			Knowing the World According to TOAD
			Using Formatter Plus for PL/SQL
			Using the Knowledge Xpert Products
			Using SQLab Xpert Tuning
			Using Benchmark Factory
			Using QDesigner
			Summary
		Index