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
FileMaker Pro 8: The Missing Manual
Replacing Data Using a Calculation
Scripting Basics
Your First Script
The Importance of the Layout
Disable Script Steps
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 16. How Big Is the World?
Hack 27. Add Google Maps to Any Web Site
Hack 41. How Google Maps Got Me Out of a Traffic Ticket
Hack 53. Add Flash Applets to Your Google Maps
Hack 67. Serve Custom Map Imagery
Twisted Network Programming Essentials
Installing Twisted
Using Authentication in a Twisted Server
Downloading Messages from an IMAP Mailbox
Downloading Usenet Articles
Providing an Administrative Python Shell
Comparing, Designing, and Deploying VPNs
L2TPv3 Pseudowire Operation
Advantages and Disadvantages of MPLS Layer 3 VPNs
Benefits and Drawbacks of L2TP Remote Access VPNs
Review Questions
Understanding VPLS
The Oracle Hackers Handbook: Hacking and Defending Oracle
The Oracle Network Architecture
Attacking the Authentication Process
Oracle and PL/SQL
Defeating Virtual Private Databases
Appendix A Default Usernames and Passwords
MPLS Configuration on Cisco IOS Software
Inter-Provider VPNs
Option 2: Inter-Provider VPNs Using ASBR-to-ASBR Approach
Command Reference
L2TPv3 Overview
Case Study 3: Implementing Layer 2 VPNs over Inter-AS Topologies Using Layer 2 VPN Pseudo-Wire Switching
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