Flylib.com
TOAD Handbook (2nd Edition)
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
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171
Authors:
Bert Scalzo
,
Dan Hotka
BUY ON AMAZON
MySQL Stored Procedure Programming
Our First Stored Procedure
Interacting with the Database
Block Structure of Stored Programs
Conclusion
The Development Process
Certified Ethical Hacker Exam Prep
Security Testing
Linux
Web Server Hacking, Web Applications, and Database Attacks
Virus and Worms
License Term and Charges
The .NET Developers Guide to Directory Services Programming
A Brief History of Directory Services
System.DirectoryServices.ActiveDirectory Overview
Searching with the DirectorySearcher
ADSI Schema Mapping Mechanism
ADFind/ADMod
A+ Fast Pass
Domain 4 Motherboard/Processors/Memory
Domain 5 Printers
Domain 1 Operating System Fundamentals
Domain 2 Installation, Configuration, and Upgrading
Domain 4 Networks
Adobe After Effects 7.0 Studio Techniques
The Many Ways to Create Selections
Rotoscoping and Paint
Working Around Limitations
Conditionals and Triggers
Particulate Matter
Special Edition Using Crystal Reports 10
Creating and Implementing Parameters Fields
Understanding the Core Functions of Crystal Enterprise
Part VII. Customized Report Distribution Using Crystal Enterprise Embedded Edition
Implementing the Interactive Viewer
Troubleshooting
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies