1 / 13

Toad Tips & Tricks

Toad Tips & Tricks. Tips for Maximizing Toad Productivity OOUG 2009 Columbus, OH July 16 th. Agenda. This is more of a “L ive-Demo ” (90 minutes) No Paper Minimal Slides – more demo in tool with Q&A (time permitting) Quest web sites offer free “Coffee Bite” Videos on such topics

malini
Download Presentation

Toad Tips & Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Toad Tips & Tricks • Tips for Maximizing Toad Productivity • OOUG 2009 • Columbus, OH • July 16th

  2. Agenda • This is more of a “Live-Demo” (90 minutes) • No Paper • Minimal Slides – more demo in tool with Q&A (time permitting) • Quest web sites offer free “Coffee Bite” Videos on such topics • www.TOADworld.com • www.askTOAD.com • Goals • Everyone, regardless of job title or Toad experience, will say: • I did not know Toad could do that (too) … • I’m walking away with 4-6 very useful tips … • Time well spent – only wish it had been longer 

  3. Bert Scalzo … Database Expert & Product Architect for Quest Software Oracle Background: Worked with Oracle databases for over two decades (starting with version 4) Work history includes time at both “Oracle Education” and “Oracle Consulting” Academic Background: Several Oracle Masters certifications BS, MS and PhD in Computer Science MBA (general business) Several insurance industry designations Key Interests: Data Modeling Database Benchmarking Database Tuning & Optimization "Star Schema" Data Warehouses Oracle on Linux – and specifically: RAC on Linux • Articles for: • Oracle’s Technology Network (OTN) • Oracle Magazine, • Oracle Informant • PC Week (eWeek) • Articles for: • Dell Power Solutions Magazine • The Linux Journal • www.linux.com • www.orafaq.com 3

  4. Books by Bert … Coming in 2009 … 4

  5. Couple of Questions (for both our benefit) • How many people using • Toad 9.7.2.5 ( most / over-half / half / under-half ) • Toad 9.6.1.0 • Oracle 10g • Oracle 11g • Current on Maintenance • Toad Free Information & Collaboration • www.ToadWorld.com • www.AskToad.com • Toad Yahoo Discussion Groups

  6. Couple of Cool Facts (for your benefit) • Toad 9.6 made the “PL/SQL Debugger” part of Standard Toad version, thus no longer requires purchasing Toad Professional just for debugger • Toad 9.7 gives you a free copy (for the same user) of our new Toad for Data Analysis – the multi-database version of Toad aimed more at people who work with the data, and who often try to use lesser tools like MS Excel • There is still a Toad freeware (www.toadsoft.com) and we’re planning a significant update to it in 2009

  7. Toad for Oracle 9.7 Developer Bundles • 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.7: • Greater workflowintegration with Benchmark Factory for Databases allowing trace files to be pushed to Benchmark Factory from Toad to initiate a workload replay test • Toad for Oracle Professional • Built with a focus on building code with 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.7: • Data generator for creating multiple rows of data for one or more Oracle tables for testing • “Top 20” rules list for performing a quick code quality check • Toad for Oracle Xpert • Designed for developers with SQL tuning responsibilities that focus on database performance • Includes functionality in Toad for Oracle Professional, plus Quest SQL Optimizer for Oracle: • Automated SQL optimization • SQL scanning • Virtual index generation • New for Toad for Oracle 9.7 – SQL Optimizer 7.4 • Better organization and usability in Batch Optimizer • New options in tuning lab • Summary report for analyzed SQL in SQL Scanner • Toad for Oracle • The development tool of choice for database professionals world wide. • The essential tool for efficient and accurate Oracle DB development, including debugging. • New for Toad for Oracle 9.7: • Querying and reporting tool (Toad for Data Analysis) included in Toad installer • Link to “Getting Started” videos • Support for Subversion VCS

  8. Toad for Oracle 9.7 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 on the database environment. • New for Toad for Oracle 9.7: • Database Browser enhancements • StatsPack and AWR advisories • Schema compare and synch enhancements • Trace File Browser • RMAN Script templates • Toad DBA Suite for Oracle • Simplify common database administration tasks and 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.7: • Tighter workflow integration with Benchmark Factory for Databases allowing trace files to be pushed to Benchmark Factory from Toad to initiate a workload replay test • The DB Admin Module must be purchased with or added onto another edition of Toad for Oracle.

  9. Toad vs. Oracle Product Release History 8.1.7.4 Oracle 9i R2 Oracle 10g Oracle 8i Oracle 9i Oct 98 Jun 99 Apr 01 Dec 01 Apr 02 Oct 02 May 03 Nov 03 Feb 00 Dec 00 v7.5 Team Coding, Adv data types in data grids v5 Quest Buys v6.1 70+ screens v6.3 PL/SQL Debugger, SQL Modeler v6.5 DBA Module v7.0 Toad Reports v7.2 Script Mgr, SQL*Loader Wizard v7.3 HTML Schema Doc Generator, Command Line Support v7.4 Project Manager, QSR Script Runner v7.6 Session Brower, New Toolbars Oracle 10g R2 9.2.0.8 Oracle 11g 10.2.0.4 11.0.1.7 Jul 04 Jun 05 Oct 05 Oct 06 Jun 07 Nov 07 Apr 08 Sep 08 v9.5 Stats Pack Browser,11g Support, PL/SQL Profiler, Code Xpert Batch Mode, SQL Opt 7.2 Integration v8.5 JIT (external) Debugging, Citrix support, RAC support, Enhanced10g support v9.0 Single MergedTabbed Editor, New & Improved Code Xpert, Oracle OEM’s ASM/ADDM/AWR Mgrs and Reports v8.6 Query Builder, New Toad “Fast” Reports, Master-Detail Browser V8.0 XML Support, Code Xpert, Script Debugger,Rebranded: Toad for Oracle v9.1 Policy Mgr, Action Recall, Toad Tips, Vista Support v9.6 Debuggerto Standard, HC Vulnerability Assessment, Improved DB Browser TDM Integration v9.7 App Designer, Trace File Browser, New Formatter, RMAN support, Toad for Data Analysis Summary: Oracle 9i >= Toad 9.0 Oracle 10g >= Toad 9.6 Oracle 11g >= Toad 9.7

  10. Oracle Client / Server Interoperability Support(See Metalink Document 207303.1) Toad may work with older client talking to newer databases - but there might be data type issues 

  11. Demo • Will use Toad 9.7.2.5 (latest & greatest GA version) • Will try to focus on three different user “personas” • Oracle SQL and/or PL/SQL Developer • Oracle Database Administrator (DBA) • Business Analyst (less technical business user) • Will show lots of feature breadth for 3 personas • Will show some feature depth for 3 personas • Will make sure to say what comes with what bundle

  12. Questions and Answers … Thank You Presenters: Bert Scalzo: Bert.Scalzo@Quest.com Note: these slides should be available on OOUG web site, but we’ll also make sure to post them on our company’s web site: www.toadworld.com/Experts/BertScalzosToadFanaticism/tabid/318/Default.aspx

More Related