---

TOAD Handbook (2nd Edition)

ISBN: 0321649109
EAN: 2147483647

Year: 2003
Pages: 171

Authors: Bert Scalzo, Dan Hotka

BUY ON AMAZON

• Main Page
• Table of content
• 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 PLSQL 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
• SQLPlus 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
• PLSQL Object Templates
• Creating a New PLSQL Object
• Using the PLSQL Navigator
• Compiling PLSQL Code
• Executing PLSQL Code
• Saving PLSQL Code to Files
• Formatting PLSQL Code
• Using DBMS_OUTPUT
• Debugging Setup, Requirements, and Parameters
• Basic Debugging PLSQL Code
• Debugging Breakpoint Options
• Advanced Debugging PLSQL Code
• Profiling PLSQL 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 PLSQL 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 ReportingNon-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 PLSQL
• Using the Knowledge Xpert Products
• Using SQLab Xpert Tuning
• Using Benchmark Factory
• Using QDesigner
• Summary
• Index
• Index SYMBOL
• Index A
• Index B
• Index C
• Index D
• Index E
• Index F
• Index G
• Index H
• Index I
• Index J
• Index K
• Index L
• Index M
• Index N
• Index O
• Index P
• Index Q
• Index R
• Index S
• Index T
• Index U
• Index V
• Index W