TOAD Handbook (2nd Edition)
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 171
Pages: 171
Authors: Bert Scalzo, Dan Hotka
- 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
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 171
Pages: 171
Authors: Bert Scalzo, Dan Hotka