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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Introduction
Configuring, Manipulating, and Reusing ORM Models
Creating a Basic Logical Database Model
Generating a Physical Database Schema
Other Features and Best Practices
The CISSP and CAP Prep Guide: Platinum Edition
Access Control
Cryptography
Application Security
Business Continuity Planning and Disaster Recovery Planning
Appendix E The Information System Security Management Professional (ISSMP) Certification
WebLogic: The Definitive Guide
Web Applications
Configuring a Mail Session
A Closer Look at the Frontend Tier
Security
JMX
101 Microsoft Visual Basic .NET Applications
Building Windows Forms User Interfaces
Interacting with the Operating System
Working with the .NET Framework
Advanced .NET Framework
Securing Applications
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Three Sales Process
Chapter Five Stimulating Interest
Chapter Thirteen Closing: Reaching Final Agreement
Chapter Sixteen Creating and Sustaining High-Performance Sales Cultures
What is Lean Six Sigma
Key #2: Improve Your Processes
Key #3: Work Together for Maximum Gain
Key #4: Base Decisions on Data and Facts
When Companies Start Using Lean Six Sigma
Six Things Managers Must Do: How to Support Lean Six Sigma
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