Discover the Hidden Treasures of Toad Bert Scalzo

Today’s Agenda • Review of Toad for Oracle (10 Quick Slides) – Quick Facts & Brief History • Which version you should use – Available Editions & Bundles • Which Edition or Bundle you should buy – Latest Version 9. 6 – but Toad 9. 7 just around the corner • Hidden Treasures (Mostly Live Product Demo) – – – Project Manager Application Designer Data Import/Export Code Xpert Quest SQL Optimizer for Oracle • Resources and Wrap-Up (Q&A)

Toad for Oracle provides efficient and accurate development and administration to Oracle database professionals of all skill and experience levels. It is the most widely-used tool of its kind on the market. Quick Facts: • • • Quest Software has owned Toad for Oracle for 10 years Considered the de-facto standard Started as freeware on www. toadsoft. com Has over one million users world wide Has a great Yahoo Toad discussion group – free – join Runs an open beta program to let users drive direction

Toad’s Long Pedigree 9 i. R 2 Original Toad Freeware Oct ‘ 98 June ‘ 99 v 5 V 6. 1 Feb ’ 00 V 6. 3 Dec ‘ 00 April ‘ 01 Dec ‘ 01 Apr ‘ 02 v 6. 5 v 7. 2 v 7. 0 Initial Quest Already has 70 Debugger, SQL DBA Module. Toad Reports. release. distinct screens. Modeler, Oracle 8 Yahoo! Groups and object support. Toadsoft. com established. Oct ‘ 02 May ‘ 03 v 7. 4 Script HTML Schema Project Manager, Generator, Manager, SQL*Loader CMD Line QSR. Wizard. Support. 9. 2. 0. 8 10 g. R 2 Nov ‘ 03 July ‘ 04 v 7. 6 v 8. 0 June ‘ 05 v 8. 5 10. 2. 0. 4 11 g. R 1 Toad for Oracle Freeware Update July ‘ 05 Oct ’ 06 Jun ’ 07 v 8. 6 v 9. 0 v 9. 1 v 7. 5 Team Coding, Data Grid support for advanced data types. Nov ’ 07 v 9. 5 Apr ’ 08 v 9. 6 Debugger into Policy Manager. Integration with Action Recall. SQL Optimizer 7. 2 Standard, Schema Debugger, Profiler, Browser merged Toad Tips Code Xpert with DB Browser, Vista support. Code. Xpert enhancements. integration with integration. Stats. Pack Browser QCTO and TDM, ASM, ADDM, AWR Oracle 11 g support. Vulnerability Mgt Assessment in Health Check Please note that any future plans represent our intentions as of the date hereof, and our development plans and Session Browser, new toolbars. XML Support, Code. Xpert, Script Debugger. Rebranded – Toad for Oracle JIT Debugging, Citrix, RAC, enhanced 10 g support. Single Merged Re-designed Editor. Modeler, M/D Brower, New Reporting Engine. Improved priorities are subject to change due to competitive factors, availability of resources and other matters common to all independent software vendors. Accordingly, these general indications of development schedules should not be relied upon if making a purchasing decision and should not be interpreted or construed as any form of a commitment that Quest will ultimately release any or all of the above-described products or features on the schedule or in the order described, or at all. The content, release, and timing of any features or functionality described above remains at the sole discretion of Quest Software, Inc. 12 July 2007

Toad for Oracle 9. 6 Developer Bundles Toad for Oracle The development tool of choice for database professionals world wide. Toad for Oracle is the essential tool for an Oracle developer to perform daily tasks efficiently and accurately. New for Toad for Oracle 9. 6: • PL/SQL debugger • Knowledge Xpert for PL/SQL and Oracle Administration • Simplified customization • Improved PL/SQL Profiler Toad for Oracle Professional Built for developers that focus on building code for quality and maintainability. Includes all functionality in the Toad for Oracle base edition, plus: • Code Xpert • Export File Browser New for Toad for Oracle 9. 6: • Import/Export utility wizards • Code Xpert – updated to simplify reporting; plus new “Toad Code Rating” – green, yellow, red Toad for Oracle Xpert Designed for developers with SQL tuning responsibilities that need to ensure optimal database performance Includes functionality in Toad for Oracle Professional, plus Quest SQL Optimizer for Oracle, which includes: • SQL Scanner • Virtual Index Generator New for Toad for Oracle 9. 6 – SQL Optimizer 7. 3 • Integration with Benchmark Factory • Users can select where code is tuned (SQL Lab or Batch Optimizer) • Users can use a “Plan” table from a different schema Toad Development Suite for Oracle Enables Database Development Best Practices and ensures that the best possible code is deployed to production. Integrated suite of three tools: • Toad for Oracle Xpert • Quest Code Tester for Oracle • Benchmark Factory for Databases Oracle Edition New for Toad for Oracle 9. 6: • Greater workflow integration with Quest Code Tester for Oracle 1. 8 New for Quest Code Tester for Oracle 1. 8 • User Interface enhancements

Toad for Oracle 9. 6 DBA Bundles Toad for Oracle DB Admin Module (formerly DBA Module) Maintain database health and stability and ensure the best possible performance, while minimizing the impact of changes to the database environment. New for Toad for Oracle 9. 6: • Health Check: Vulnerability Assessment • AWR Browser • Enhanced DB Browser • Flashback archives for Oracle 11 g Toad DBA Suite for Oracle Simplifies common database administration and helps you become more proactive in solving database-related performance issues before end users are impacted. The suite includes: Toad for Oracle Xpert, with DB Admin Module; Spotlight on Oracle Standard Edition; Toad Data Modeler; Benchmark Factory for Databases Oracle Edition New for Toad for Oracle 9. 6: • Tighter workflow integration with Toad Data Modeler New for Toad Data Modeler 3. 1 • Live reverse engineering making it easier to add entities to models • Generate alter reports that include changes between two models from the Convertor and Comparator dialogs • Import models from Toad Data Modeler 2. 0 • The DB Admin Module must be purchased with or added onto another edition of Toad for Oracle.

Toad for Oracle 9. 6 Bundle Updates Base Edition • Debugging moved to base edition (this includes DBMS, JDWP, External and SQL*Plus Script debugging) • Knowledge Xpert for PL/SQL moved to base edition • Knowledge Xpert for DBA moved to base edition Professional Edition • Oracle Import Utility moved to Pro (still in DB Admin module) • Oracle Export Utility moved to Pro (still in DB Admin module) DBA Module • Now called the DB Admin Module 7

Toad for Oracle 9. 6 Functionality Updates Base Edition • • Improved initial setup Toolbar/Menu customization Code Editor Insight updates Profiler Analysis updates DB Admin Module • • Database Browser updates Vulnerability Assessment added to database Health Check AWR Browser Additional support for 11 g (Flashback archives) Integration with other Quest Products • • • Quest Code Tester for Oracle 1. 8 Toad Data Modeler 3. 1 Quest SQL Optimizer for Oracle 7. 3 – Select way in which you want to optimize – Batch optimizer enhancements and new options 8

Toad for Oracle 9. 7 work is wrapping up • • • • • Parser Updates (Base) Data Generation (Professional) Action Recall enhancements (Base) Code Xpert enhancements (Professional) Database Browser (DB Admin Module) RMAN Scripting Templates (DB Admin Module) Stats Pack and AWR Advisories (DB Admin Module) Trace File Browser (DB Admin Module) Schema Compare enhancements (Base – basic compare & DB Admin Module – Compare using Def Files & Sync) Integration (Dev Suite & DBA Suite) Benchmark Factory Subversion support (Base) Getting Started videos (Base) Oracle Licensing notification Window disabling Oracle Version check Toad Customer User files

Now it’s Time to Discover the Hidden Treasures of Toad®

Project Manager • Share project assets such as templates, scripts, and code snippets • Maintain code consistency • Ensure adherence to standardization and formatting

Application Designer • In 9. 6 feature introduced as Action Palette, but then in 9. 7 renamed to App Designer • Record workflow steps in Toad and store for future use • Recall actions for execution and modification • Schedule actions to run automatically

Data Import/Export • Extract objects and data subsets from an Oracle export file • Reduces need to import an entire Oracle export file • Decreases program errors and saves time

Code Xpert • Automate the process of performing objective code quality reviews • Check code against a pre-defined set of rules • Help ensure database development best practices are followed

Quest SQL Optimizer for Oracle • • Automate the SQL optimization process and generate replacement SQL Analyze indexing strategy & perform Index Impact Analysis

Resources and Next Steps • Toad World: www. toadworld. com – Blogs, articles, tips and tricks, special offers • Technical Briefs – Implementing Database Development Best Practices for Oracle – What's New in Toad for Oracle 9. 6 • White Papers – Discover the Hidden Treasures of Toad – Engineering Better PL/SQL for Simpler, More Effective Database Applications – Simplifying Oracle Database Administration – The Oracle Database Administrator of Tomorrow: The Impact of New Technologies – Maximize DB Performance via Toad • Trial Downloads: http: //www. quest. com/toad-for-oracle/software-downloads. aspx

Thank you Presenter: John Pocknell E-mail: john. pocknell@quest. com