Enabling Database Development Best Practices - Insight Web Server

DATASHEET

Toad

®DEVELOPMENT

for Oracle

SUITE

Enabling Database Development Best Practices

BENEFITS

Oracle database professionals rarely have total control over their development environments because it is constantly changing. These changes typically result from new development projects or modifications to existing code, and when they are deployed to production, they do not always produce the intended result. Depending on the severity of the problems, the consequences can range from additional development cycles that hamper productivity to downtime that negatively impacts the bottom line.

• Boost productivity by automating frequent and repetitive tasks using predictive editing and code refactoring

Additionally, when development teams are dispersed in many locations and its members have skills that vary widely, it’s difficult to consistently ensure top-quality results. But using a proven methodology that takes the entire development lifecycle into account, you can help guarantee success by deploying the best possible, highest-performing applications to production.

• Lower the total cost of ownership for new applications by reducing the impact of inefficient code on productivity, future development cycles, performance and availability

For organizations to better manage development projects and the teams that develop code, Quest Software’s Toad Development Suite for Oracle offers a set of guiding principles based on a best practices methodology. Quest’s Oracle domain expert, Steven Feuerstein, and Toad® for Oracle’s loyal customer base were instrumental in developing the methodology. It provides a consistent, repeatable and measurable process that even novices can use to manage the database development process, ensuring that the best possible code is deployed to production.

• Deploy high-quality, reliable applications that meet user requirements and service levels

DATASHEET

The Toad Development Suite for Oracle consists of three integrated products:

Toad for Oracle Xpert

SYSTEM REQUIREMENTS Platform

• Use Toad for Oracle, the world’s leading development tool, to build, edit and maintain your code

• 1 GHz processor (Spotlight requires 1.2 GHz processor)

• Validate database code to ensure the best possible performance

Memory

• Leverage the “Auto Optimize” feature to easily improve SQL code, directly within the Toad Editor

• 924 MB RAM required, 1 GB recommended

Quest Code Tester for Oracle • Perform practical and thorough functional code testing for PL/SQL without lengthy test scripts • Run tests as you develop code or as regression tests before the code enters production, reducing the risk of costly bugs and functional errors over years of use and maintenance

Benchmark Factory for Databases • Conduct repeatable and measurable testing for performance and scalability • Replay database workload to simulate production activity levels prior to deployment

Benefits With the Toad Development Suite for Oracle, you can ensure the code that you deploy is tested, it functions properly, and it is optimized. It allows you to: • Automate frequent and repetitive tasks and make the development organization more productive • Successfully deploy high-quality applications that perform reliably in production as well as meet user requirements and ensure service levels are met • Lower the total cost of ownership for new applications by reducing the impact of inefficient code on productivity, future development cycles, performance and availability

About Quest Software, Inc. Now more than ever, organizations need to work smart and improve efficiency. Quest Software creates and supports smart systems management products—helping our customers solve everyday IT challenges faster and easier. Visit www.quest.com for more information.

Operating System: • Windows 2000, XP, 2003, Vista, 2008 and Windows 7 (32-bit and 64-bit) Notes: • When running on a 64-bit operating system, you must use the 32-bit Oracle Client. • In Windows Vista, you must use a logon with the Admin privilege or if you are logged on as a normal user, you must have the Universal Access Control (UAC) turned OFF.

Product Exceptions • Spotlight on Oracle: Requires Windows 2000 (Service Pack 4 or later) or Windows XP (Service Pack 1 or later) • Toad Data Modeler: Requires Windows 2000 (Service Pack 4 or later) • Toad for Data Analysts: Does not support Windows 2000, Windows 2003 (64-bit), DB2 connections on Windows XP (64-bit only)

Database Client • Oracle 8i Client (Net 8), • Oracle 9 Client (Net 9), • Oracle 10 Client (Net 10) or Instant Client 10, • Oracle 11 Client (Net 11) or Instant Client 11.1.0.7 Note: Only the 32-bit Oracle client is supported.

Database Server • Oracle versions 8.0.6; 8.1.7; 9i; 9iR2; 10gR1; 10gR2; 11gR1, 11gR2 Product Exceptions • Quest SQL Optimizer for Oracle: Requires Oracle 8.1.7 or later • Spotlight on Oracle: Requires Oracle 9.2.0.4 or later and SQL*Net 2.3.4 or later • Toad for Data Analysts: Requires Oracle 9i or later

Additional Requirements: • VGA monitor, 1024x768 resolution, small fonts (Spotlight requires 1280x1024 or larger) Toad now supports the following Cloud databases: Oracle on Amazon EC2 as well as the following Virtualized environments: Application: Citrix support on Windows Server 2003 (Service Pack 2) using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2 5 Polaris Way, Aliso Viejo, CA 92656 | PHONE 800.306.9329 | WEB www.quest.com | E-MAIL [email protected]

If you are located outside North America, you can find local office information on our Web site. © 2010 Quest Software, Inc. ALL RIGHTS RESERVED.

Desktop (VDI): Quest vWorkspace 7.0 on Windows XP Professional 32-bit (Service Pack 2) Server: VMWare ESX Server 3.5 and VMWare Server Console 1.0.10 on Windows Server 2003 (Server Pack 2)

Quest Software and Toad are registered trademarks of Quest Software, Inc. in the U.S.A. and/or other countries. All other trademarks and registered trademarks are property of their respective owners. DSD-ToadDevSuiteOracle-US-AG-20100430