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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Retrieving Data from an Oracle Package
Adding Parent/Child Rows with Auto-Incrementing Keys
Updating a DataSet with a Many-to-Many Relationship
Binding Complex Data to Web Forms Controls
Displaying an Image from a Database in a Web Forms Control
Network Security Architectures
Impact of Network Security on the Entire Design
Organizational Realities
Case Studies
MySQL Cookbook
Issuing Queries
Validation by Pattern Matching
Generating Repeating Sequences
Using Transactions in Python Programs
Loading a Database Record into a Form
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 6. Share Google Maps
Hack 10. Add a Google Map to Your Web Site
Hack 25. Track Your UPS Packages
Hacks 5161: Introduction
Hack 57. Do a Local Zoom with GxMagnifier
Twisted Network Programming Essentials
Working with Asynchronous Results
Accepting Connections from Clients
Uploading a File
Managing a Hierarchy of Resources
Storing Web Data in an SQL Database
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Multithreading
Network Programming
Windows Controls
ASP.NET Web Applications
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