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


TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net