Toad™ for Oracle® 2015 Functional Matrix

Toad for Oracle

Base Edition Professional Xpert Edition DB Admin Development DBA Suite DBA Suite
Edition Module (add- Suite RAC or
Essential Functionality on) Exadata Eds.

Runs directly on Windows OS      

Browse and navigate through objects      
Create and manipulate database objects through graphical
     
interfaces
Edit: snippets, predictive typing, syntax highlighting, code folding,
     
spell check
Customize code templates and code formatter      
Save, nickname & share previously executed SQL      
Unicode support      
Development Functionality
Query Builder      
Integrated Debugger      
Automated traditional DBMS_OUTPUT debugging      
Advanced ER Diagram with HTML reporting and e-mail      
Build database code dependencies diagram (Code Road Map)      
Compare code difference in database objects and files      
External/remote debugging (used when the DB code is called from
     
apps. like Java, C++, VB, etc.)
Support for APEX development      
Convert embedded SQL to other programming languages (Delphi,
     
C, C++, Java, Perl and VB etc.)
View multiple results sets from executed SQL scripts      
Load and unload multiple Java source files      
Store PL/SQL execution parameters for re-use      
Browse Oracle Export file content and selectively extract objects
     
and data
Automatically identify unit tests out of synch with corresponding

database source objects
Automate functional code test creation and unit test execution 

1 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Team Collaboration on) Oracle or Exadata
Eds.

Share files, code templates, options, and connections (requires Toad

     
Intelligence Central).
Enforce standards with shared code review rule sets and formatting
     
options (requires Toad Intelligence Central).
Integrates with popular version control system providers      
Perform checkpoints through automated code review validation
     
prior to version control check-in
Manage project assets      
Import and Export Code Quality Rules and Rules Sets for team
    
sharing
Code Analysis & SQL Tuning
PL/SQL profiling to detect code performance bottlenecks      
Visual SQL explain plan      

Trace user sessions and visually display Oracle Trace File Output   

Display session info & performance metrics      

Automate code analysis and validation against SQL and PL/SQL
    
coding Best Practices
Automated, configurable, objective code review & analysis with
    
reports, maximizing code quality
Identify coding best practice violations dynamically during editing    

Analyze code quality metrics across database environments and

    
over time (requires Toad Intelligence Central)
Identify problematic SQL directly from database objects, files, and
   
source code
Automate SQL rewrites to locate the most- efficient SQL alternative
   
(internal to Editor and full external optimizer)
Optimize multiple SQL statements in batch in context with the
   
source code and provide optimized code
Seek Oracle SQL tuning suggestions via the Oracle Tuning Advisor
     
(requires Tuning & Diagnostics Packs)

2 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Code Analysis & SQL Tuning (cont.) on) Oracle or Exadata
Eds.

Recommend indexing changes based on continuous database

   
workload assessment
Analyze impact of changes to database environment through index
   
simulation
Test SQL and PL/SQL for scalability under simulated user loads to
  
validate performance under production conditions
Track real-time SQL executions from client applications to help
     
locate issues or perform QA
Track real-time SQL executions on test or development servers to
   
help locate issues or perform QA on client applications
Schema, Data, and Change Management
Advanced, highly productive data grids offering simple column
     
selectivity and grouping
Import/export data from data grid into/from Excel files and other
     
formats
Data compare and synch      
Display table data representing Parent-Child dependencies (Master
     
Detail Browser)
Reverse engineer objects DDL including roles & permissions to
     
recreate objects in a different db/schema
Compare schemas using live connections      

Compare schemas efficiently with offline snapshot or definition files     

Compare one schema source to multiple targets      

Sync one schema source to multiple targets     
Compare and generate Multi Schema change scripts between two
  
database environments
Generate test data (randomized or real-world)     
Oracle Import/Export utilities      
Oracle Spatial data support      
Oracle LogMiner support    

3 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Schema, Data, and Change Management (cont.) on) Oracle or Exadata
Eds.

Analyze the performance impact of new indexes, index changes and

   
parameter changes on SQL
Analyze the performance impact of moving SQL statements from
   
database to another
Analyze SQL execution plan changes between database
   
environments (i.e. dev. vs. prod. or Oracle 9i vs. 10g)
Replay scalable database workload to simulate production load
levels in a test environment prior to deployment or implementation   
of database or platform changes
Reverse engineer database schema into a physical data model,
     
compare with another version and generate alter script
Reverse engineer physical data model into a platform agnostic
     
conceptual data model
Round-trip engineer from database or DDL between different
     
database platforms such as Oracle, SQL Server, Sybase, DB2, etc.
Compare and generate schema change scripts between two or
   
more schema versions
Compare and generate schema change scripts between two or
   
more versions of offline schema snapshot files
Compare and generate database server change scripts between two
  
or more databases
Compare and generate database server change scripts between two
  
or more versions of offline database snapshot files

4 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Reporting on) Oracle or Exadata
Eds.

Generate customizable schema and database reports in HTML

     
format
Automate report generation and distribution      
Generate code review reports covering all aspects of code quality
    
assessment
Generate reports on 212 aspects of database performance,
configuration (inc virtualized databases and Exadata), schema, RAC   
and security vulnerabilities
Multi-database reporting and analysis dashboard for Oracle RMAN
  
backups
Generate reports on potentially problematic SQL and optimizartion
   
results
Database Administration
Control access to protected databases       
Browse multiple servers and databases, perform tasks and drill down
  
to object level
Browse and navigate database-specific objects like tablespaces and
      
roles
Direct access to Oracle Alert log and Oracle Trace files to quickly
  
diagnose issues
Manage database objects, such as tablespaces and rollback
      
segments
Display performance metrics from V$, GV$ (RAC) and SGA   
Export APEX Objects from database   

Use of OEM Use of OEM Use of OEM Use of OEM

Packs by Packs by Packs by Packs by
Toad Toad Toad Toad
Check database for security vulnerabilities and usage of Oracle OEM
controlled controlled controlled  controlled  
Options and Packs and produce reports by Initial by Initial by Initial by Initial
Setup Setup Setup Setup
Wizard Wizard Wizard Wizard

Execute one or more scripts against one or more Databases      

5 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Performance Diagnostics and Tuning (Oracle instances) on) Oracle or Exadata
Eds.

Integrate with OEM's performance pack with Oracle Tuning Advisor*      

Identify top sessions and resource-intensive SQL      

Playback historical activity on Oracle instances to find the source of
 
performance issues
Simple, highly visual alert-based point-and-click problem resolution
 
for Oracle databases including contextual launching from Toad
Simple, highly visual alert-based point-and-click problem resolution
 
for Unix, Linux or Windows- based servers
Performance diagnostics for Oracle Data Guard  
Simple, highly visual alert-based point-and-click problem resolution
 
for MySQL databases
Monitoring of Oracle OEM  
Perform database predictive diagnostics to pre-empt and mitigate
 
potential future performance bottlenecks
Perform 161 database health checks including Performance
  
Configuration and Storage featuring Virtualized environments
Collect data from Oracle StatsPack or AWR * and display advisories
  
to correct potential performance issues
Manage space, repair chained rows and estimate space usage   
Performance Diagnostics and Tuning and Change Management (Oracle RAC and Exadata)
Perform 212 database health checks including Oracle RAC
  
configuration and Exadata
Simple, highly visual alert-based point-and-click problem resolution

for Oracle RAC and Exadata
Visualize instance, cluster and interconnect levels for Oracle RAC

performance diagnostics
Enables DBAs to launch Spotlight on Oracle directly in context with

an instance exhibiting performance issues
Playback historical activity to find the source of performance issues 

6 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Performance Diagnostics and Tuning and Change Management on) Oracle or Exadata
(Oracle RAC and Exadata) cont. Eds.

Perform industry standard benchmark testing on Oracle RAC to

 
determine optimum CPU/node configuration
Replay database workload to simulate production load levels in a
test Oracle RAC environment prior to deployment or  
implementation of RAC configuration, database or platform changes
Visualize and diagnose real-time performance problems in Oracle
Exadata environments including storage server nodes, Smart Scan 
and Smart Flash Cache
General
Read-only mode      
Restrict access to Toad features      
Direct access to feature-based videos      
Direct access to product windows, menus, options, support portal
and online articles/blogs on user community with single click using      
a Jump Search bar
Get help from online user community by reading Blogs/Articles and
     
Participate in forums, with in the product
Context-sensitive PL/SQL knowledge base, including best practices,
     
worked examples, error messages and much more
Distribute and optionally enforce configurations and settings to
     
group of users
Share SQL Scripts and Files with the Toad World Community via a
     
secure public repository
Share SQL Scripts and Files with colleagues within company
     
network via private repository
Remotely access and execute SQL scripts via a web application
     
(MyToad)
Synchronize Toad for Oracle User Files in the cloud with Dropbox
     
(MyToad)
Share, schedule and automate tasks across one or more databases
     
with macro/action record and playback

7 June 2015
 Toad™ for Oracle® 2015 Functional Matrix
Toad for Oracle
Base Edition Professional Xpert Edition DB Admin Development DBA Suite for DBA Suite for
Edition Module (add- Suite for Oracle Oracle RAC
Multi-database Functionality** on) Oracle or Exadata
Eds.

Query and report on multiple database platforms: Oracle, SQL

Server, DB2, MySQL, Access, Teradata, Netezza, PostgreSQL, Sybase
     
IQ, Sybase SQL Anywhere, Vertica and more from a single
interface**
Integrated tools for query development including Query Builder and
     
Editor**
Perform heterogeneous queries**      
Import & Export utility**      
ER Diagram & database browser**      

Graphical automation of workflow tasks for re-use and scheduling**      

Pivot Tables, charting and comprehensive reporting**      

Reverse engineer database schema into a physical data model,
     
compare with another version and generate alter script***
Reverse engineer physical data model into a platform agnostic
     
conceptual data model***
Round-trip engineer from database or DDL between different
database platforms such as Oracle, SQL Server, Sybase, DB2, Ingres,      
etc***

* Optional functionality. May access OEM packs. This is disabled by default.

** Delivered through Toad Data Point, available as an add-on to your Toad license.
*** Delivered through Toad Data Modeler, available as an add-on to your Toad license.
Please Note: Dell relies on information from a variety of sources in preparing this document. While every attempt is made to ensure its accuracy,

8 June 2015