|
Toad for Oracle:
Downloads:
Resources:
|
Get to Know 9.5
Missed 9.1? Read about that here
Introduction
Each release of Toad™ for Oracle brings a new feature set to be discovered by
its users. Ideally, users would read through the Release Notes and the Help to
discover the new features. However, we all know this is frequently not a
realistic goal for busy IT professionals. This document provides a quick
walk-through of some of the new features being introduced in Toad for Oracle
version 9.5.
Note: This tutorial/walk-through was written using Toad
BETA release version 9.5.0.28
Installer Updates
Toad for Oracle 9.5 will now be bundled in the Quest Installer, either as a bare-bones Toad install
or packaged together with other Quest Software applications. Features include:
- An intuitive, streamlined installation wizard
- All MSI install applications are launched transparently from the main Quest Installer
- Fewer wizard screens
- Ability to configure other Quest products, including the Group Policy Manager
Toad as always still supports the Standalone, Network, and Citrix
installation types
The StatsPack Browser
Oracle statspack tables were introduced in release 8i, so we decided it was high time to take advantage of what they have to offer.
The Toad StatsPack Browser (DBA module required) takes beginning and ending snapshots of database performance statistics and then offers graphical trending
and time-series analyses based on those stats. The result is a gallery of useful charts for interpreting database performance.
A sampling of some of the StatsPack graphical charts
Each chart's right-click menu supports the ability to print, save as an image file, or send data to Excel
The 11g Hierarchical Profiler
Toad for Oracle's Profiler has been around for years, and now for Oracle 11g, it features a tree-based hierachy for profiling
PL/SQL code. Users can now isolate more granular elements in their code's call stack.
Simple and customizable, the configuration of the hierarchical profiler is in a tab within the Set Parameters dialog
The QP5 Parser
The QP5 Parser offers full 10g syntax support by way of the latest parsing technology. QP5 is multi-threaded and supports
several OS platforms. Additionally, redesigned code layering allows more abstraction to
make such layers reusable, and an internal binary API offers better development scalability and simplifies code complexity. Other
features include:
- Incremental parsing - allows processing to be done on a statement-by-statement basis
- Name resolution - QP5 does not directly access the database
- Control Flow Analysis and Data Flow Analysis - both CFA and DFA results can be used by tools like CodeXpert
- Template based formatting - user can define templates or use defaults
Miscellaneous Features
- Quest SQL Optimizer version 7 - now runs as a standalone application and provides more complete code scanning
- Editor case preservation - save to file or copy to clipboard once again preseves case properties
- Schema Browser - right hand side detail panel reflects left side and allows quick describes or copy to clipboard as HTML
- Expanded "Ctrl+click" functionality - allows deeper control of mouse click actions on object names
- Project Manager multiple project support - two or more project file tabs can be opened at once
- Auto-add integration - Toad 9.5 now recognizes Quest Code Tester and other products, and allows them to be added as launch icons
- Create table - LOB Editor in the Create/Alter window allows configuration of large object parameters
- Session Browser - Six new columns added: CPU, CPU This Call, UGA Memory, PGA Memory, Rollbacks and Commits
- CodeXpert - largely rewritten to scan code faster and offer better command line support
For questions or comments on this site: webmaster@toadsoft.com
All
content Copyright © 2006 Quest Software, Inc.
All rights reserved.
|
