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
WebLogic: The Definitive Guide
WebLogics Wrapper Drivers
Node Manager
An Overview of Clustering
Programmatic SSL
Monitor MBeans
Java How to Program (6th Edition) (How to Program (Deitel))
Color Control
Introduction
Generic Classes
Terminology
Exercises
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Launching the Designer Client
An Introduction to Formula Language
The Five Primary Application Types
Parse a Text String
Retrieve All Views in a Database
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 10. Georeference Digital Photos
Hack 58. Dont Lose Your Tracklogs!
Hack 84. Build a Free World Gazetteer
Hack 89. Publish Your Geodata to the Web with GeoServer
Hack 93. Node Runner
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Cause and Effect
Blue-Screen Garbage Mattes
Making Movies from Stills
Scale and Speed
Custom Scene Transitions
Python Standard Library (Nutshell Handbooks) with
The cStringIO Module
The md5 Module
The xdrlib Module
The CGIHTTPServer Module
The statvfs Module
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