What's in the DB Admin Module
Note: This information was written using Toad Beta 9.7.0.10.
Some of these features are also available in the Toad Professional Edition. These features are marked with an asterisk (*), and are noted as available in both places in their descriptions.
ADDM/AWR Report Generator
Create performance analysis reports from Oracle’s Automatic Workload Repository. Also manage snapshots and baselines.
Screenshots
Analyze All Objects
This window is available in the base version of Toad, but when the DB Admin module is added, statistics
can be easily exported, imported, or copied to another schema or database.
Screenshots
ASM Manager
Use to manage the Oracle DB file system from within the Oracle database. Create, alter, view contents of, and drop, Disks and Disk Groups.
Screenshots
Audit Objects
Display the audit monitoring options for selected database objects. Quickly define auditing options for single or multiple objects.
Screenshots
Audit SQL/Sys Privs
Display the audit monitoring options for SQL Statement Objects, Reserved Words and System Privileges in the database.
Screenshots
AWR Browser
View Oracle AWR data in predefined or custom charts and grids. Easily observe trends between snapshots.
Screenshots
Code Road Map and ER diagram
The Create Object scripts button on both of these windows is only available with the DB Admin Module. See Code Road Map and ER Diagram.
Screenshots
Compare Databases
Compare Database-level objects such as tablespaces, roles, users, etc. between databases or Database Definition Files.
Screenshots
Compare Schemas
The Compare Schemas screen is available in the base version of Toad, but the DB Admin module allows you to use
the synchronization script. The DB Admin module also allows Toad to compare a Schema Defintion File to a live
schema, or another Schema Definition File. A Schema Definition File is a propriety, binary file, which stores
the metadata of a live schema.
Screenshots
Control Files
The control file contains information about the associated database that is required for the database to be accessed by an instance, both at startup and during normal operation. A control file's information can be modified only by Oracle; no database administrator or end-user can edit a database's control file. This option allows you to view them.
Screenshots
Database Browser
Browse databases from server level all the way down to the object level. View aggregated information about multiple databases on the same server. The Database Browser serves as an organization tool and launch point for many tuning/troubleshooting windows within Toad.
Screenshots
Database Health Check
The Database Health Check performs a series of checks on a selected database and displays the results. Includes a “Vulnerability Assessment” to help find places where your database could be vulnerable to hackers. Includes a differences report to see what has changed since Health Check was last run. Results can be saved to HTML and sent by email.
Screenshots
Database Monitor
Allows you to monitor database performance with nine charts: Logical IO, Physical IO, Event Waits, Sessions, Call Rates, Miss Rates, SGA Memory Usage, Shared Pool, and Indexed Queries %. There is a horizontal scroll bar to allow you to see all the charts.
Screenshots
Database Probe
This real-time monitoring window offers a large collection of alerts. You can also create your own alerts.
Screenshots
DataPump Import/Export Wizards*
This feature is available in either Toad Professional Editions or the DB Admin Module. The Oracle data pump is an import/export utility added in Oracle 10g. It is significantly faster and more efficient at loading large volumes of data than the standard import/export utilities. Toad's Data Pump import/export wizards make using it even easier. In addition, Toad has a data pump job manager to help you manage import/export tasks.
Screenshots
DBMS_FLASHBACK
Use this window to “look back in time” in your database, using Oracle’s DBMS_FLASHBACK package on Oracle version 9i and up.
Screenshots
DBMS_REDEFINITION Wizard
Use this wizard to rebuild tables online using Oracle’s DBMS_REDEFINITION package on Oracle version 10 and up.
Screenshots
Flat File Export
The SQL*Loader tab is only available with the DB Admin Module.
Screenshots
Generate Database Script
Generate DDL for all (or some) non-schema objects such as tablespaces, roles, profiles, etc. Script can be dependency-sorted. Extract from a live database or Database Definition File.
Screenshots
Generate Schema Script
Generate DDL for all (or some) objects in a schema. Script can be dependency-sorted. Extract from a live schema or Schema Definition File.
Screenshots
Identify Space Deficits
This displays tables that do not have enough free disk space to allocate their next extent.
Screenshots
Index Monitoring
Monitor indexes to determine whether or not they are being used. You can then drop unused indexes to eliminate unnecessary overhead.
Screenshots
Instance Manager
The Instance Manager is designed to let you check on the status your database instances. The Instance Manager can send email alerts when the status of an instance changes. The Instance Manager can start, stop, and alter your database instances.
Screenshots
Log Switch Frequency Map
This screen shows when your database performs a log switch. You can use this window to judge the balance of log switches.
Screenshots
LogMiner
If a System Change Number (SCN) caused a corruption problem, LogMiner lets you easily analyze a database and recover to the transaction exactly before the corruption.
Screenshots
New Database Wizard
The Toad Database Wizard provides a rapid way for DBAs to create Oracle databases. It offers an easy wizard-style interface consisting of 5 screens prompting the user to select parameter values for the construction of the database parameter file (INIT.ORA) as well as values used in the construction of a SQL file that can then later be executed by either a batch file (Windows) or a script (UNIX) the wizard generates.
Screenshots
NLS (National Language Support) Parameters
View the Session, Instance, and Database parameter settings, and change the Session and/or Instance parameters.
Screenshots
Operating System Utilities
Screenshots
- Unix Monitor – You can monitor database performance with three charts and a grid: CPU Usage, Process Queues, Disk IO in Kb/Sec (for the top 10 devices), and a process list grid that breaks the information down by user. The process list displays the top 20 CPU usage processes, sorted by %CPU as a default.
- Unix Job Scheduler - You can schedule jobs to a Unix machine.
- Windows Registry Parms - You can easily set Windows Registry parameters to make Toad and Oracle run more efficiently.
- Unix Kernel Parms - You can easily set Unix Kernel parameters to make Toad and Oracle run more efficiently.
- Service Manager - You can start, stop, and check status of services on local or remote PCs running Windows
Oracle Parameters
Although you can view Oracle Parameters with Base Toad, the DB Admin Module allows you to Alter Parameters.
Screenshots
Pinned Code
Pin code into the memory buffer so that it is always accessible and not overwritten by new data.
Screenshots
Redo Log Manager
Understand your redo log configuration at a glance. Redo log groups and members can be created or dropped. Clear log groups, force a log switch, or perform various "alter system archive log" commands.
Screenshots
Resource Plan Scheduling
Easily schedule and change schedules for resource plans.
Screenshots
Schema Browser and Database|Create Menu
Create, alter, compare, drop, view information about, and manage the following object types:
Screenshots
- Contexts
- Dimensions
- Directories
- Flashback Archives
- Libraries
- 10g Scheduler Objects
- Chains
- Jobs
- Job Classes
- Programs
- Schedules
- Windows
- Window Groups
- Policies
- Policy Groups
- Profiles
- Refresh Groups
- Resource Consumer Groups
- Resource Plans
- Roles
- Rollback Segments
- System Privileges
- Tablespaces
Segment Advisor
Examine tables, indexes, and partitions to determine if and how much, space can be reclaimed in them with the SHRINK command.
Screenshots
Statspack Browser
View Oracle Statspack data in predefined or custom charts and grids. Easily observe trends between snapshots.
Screenshots
Tablespace Map
This map provides a graphical view of the contents of your tablespaces.
Screenshots
Top Session Finder
You can find the sessions in the database that are consuming the most resources. Oracle tracks hundreds of statistics for each session in the database, and the Top Session Finder lets you easily sort the sessions by their usage of any combination of parameters.
Screenshots
Trace File Browser
Quickly and easily view the contents of an Oracle Trace File in an interactive utility.
Screenshots
Undo Advisor
The Undo Advisor provides advice and helps to automate the establishment of the database undo environment. The advisor can inform you about the health of the current undo configuration, either overall or within a given time range.
Screenshots
View Tablespaces
The Space, Space History, and IO History tabs are only available in the commercial version of Toad with the optional DB Admin Module.
Screenshots
For questions or comments on this site: webmaster@toadsoft.com
All
content Copyright © 2008 Quest Software, Inc.
All rights reserved.
|
