Toad for Oracle__oracle

　　TOAD (Tools of Oracle application developers) is a specialized, graphical tool for pl/sql development tools that help developers and DBAs to do their work effectively. It is a powerful, low load development tool, Integrated mode browsing, SQL programming, Pl/sql Development and debugging, DBA Management, SQL statement optimization and many other functions. It is the most important feature is easy to use, access speed. With Toad, we can quickly access the database through a graphical user interface to complete complex SQL and Pl/sql code editing and testing. Designed for developers, Toad is a powerful, compact and specialized pl/sql development environment.

Toad includes basic modules and optional modules, each module is quoted separately, and users can choose the most suitable products according to their development and management requirements.
1. Basic Module
The Toad basic modules provide the following key features:

Advanced SQL Editor, you can edit, run, and adjust SQL statements.
TOAD includes numerous features to increase the level of production that developers write SQL statements. For example, simply generate a code template, automatically discover the contents of the package and the name of the column before writing SQL, and so on. The SQL Editor includes an edit window and a Run Results window that allows developers to test the results of the run during the editing process. The SQL Editor includes not only standard editing commands, but also some enhancements, such as fields in a quick query table, formatting the contents of an SQL statement, and so on. This window can handle large to 4GB content and is useful for large development projects. Handy bookmarks make it easy for developers to find relevant locations. You can provide user-defined configuration functionality in the Run Results window, support long and long raw columns, and unload data to disk, print data, edit data, and so on.
Stored Procedure EditorFor editing, compiling, testing, and debugging stored procedures and triggers.
Toad provides syntax identification, error identification, and many other features that are easy to use, such as displaying table names, column names, and Oracle functions in pop-up windows. Unlike other pl/sql editing tools, TOAD allows you to manipulate multiple database objects in one file, compile an object, compile multiple objects, compile to the current cursor, and compile from the cursor. The stored procedure stops to the problematic statement when there is an error running. Users can use shortcuts or templates to quickly write pl/sql, or to generate their own templates as needed. You can easily edit with toad, such as setting bookmarks, uncomment, format SQL statements, and so on.
Mode Browsing, allows us to quickly access the data dictionary and browse the tables, indexes, and stored procedures in the database.
Toad provides fast access to the database, uses extremely convenient, the user interface is concise, the structure arrangement is reasonable. When we click on a separate database object, Toad immediately displays the details of this object. For example, when we click on a table for a database, all of the indexes, constraints, stored procedures, SQL statements, and other tables associated with this table are displayed in the same interface. To simplify operations, users can manipulate database objects in the Browse window.
SQL Modeler, it can help developers write complex SQL statements easily, and can write complex queries simply by dragging the mouse.

2. Optional Modules

In addition to the basic modules, Toad also provides the following optional modules to help with different functions.

2.1. DBA Module
DBA module provides a simple and sophisticated DBA management environment that enables authorized developers to master a number of common administrative tasks, such as a quick understanding of the schemas of a database, space management, modification of user rights, generation of schema scripts, and modification of the NLS (national Language Support) parameters, and so on, all of which are intuitively included in the Toad interface; DBA module imports and exports data through the graphical interface, making it easy and efficient to load and unload data, while DBA module provides the ability to create, modify, and remove all DBA-managed objects through an Easy-to-use schema-browser interface.
2.2. Formatter Plus
Formatter Plus is a powerful, flexible format and analysis tool. It supports Pl/sql, SQL, and sql*plus applications. You can format the entire application or a single file immediately, check the format, and give the best advice on code correctness, maintainability, readability, efficiency, and the structure of the program. This improves the maintainability of the code and increases the performance of the application system. Reduce the chance of application errors and improve the efficiency of application development.
2.3. Pl/sql Debugger
Toad provides easy-to-use Pl/sql debugging capabilities to save developers valuable time for development and testing in large projects, and to improve the quality of application development. In the process of developing a stored procedure, Toad can edit, debug, and run code line by row. The runtime can input parameters according to need, observe the changes of related parameters to check the correctness of the stored procedure. During the modal process, Toad can display all breakpoints, parameters, call stacks, and output parameters through a window. With Toad, it is very easy to detect errors in stored procedures, and developers can run PL/SQL statements to identify the problem step-by-step. A debugging session can be performed concurrently with other program sessions.
2.4. Xpert Tuning
Sqlab Xpert is a powerful SQL tuning tool, built with well-known Oracle expert SQL optimization experience, can quickly discover and optimize bad SQL statements, achieve efficient database tuning.
Sqlab Xpert can quickly and intelligently find database, index, schema, and SQL statement performance issues, propose optimization recommendations, or automatically rewrite SQL statements. Advanced tuning laboratories can be optimized in a variety of debugging and production environments and combined with interactive, quantifiable performance analysis and plain charting.
Sqlab Xpert integrates the Windows interface, context-sensitive SQL optimization environment, and the recommended functionality that Oracle's renowned experts have accumulated over the years to identify and optimize bad SQL statements and indexing patterns and eliminate I/O bottlenecks. By integrating with the tracking information for Oracle SQL, all SQL statements can be found and optimized in the tuning lab.

Figure: Using Sqlab Xpert to find bad SQL statements
Sqlab Xpert can monitor the activities of SQL statements for different user processes and objects, find out bad statements, and explain and optimize them. Because you do not need access to the application code, you can test both the suite application and the self-developed application.

Figure: Sqlab Xpert Laboratory
Sqlab Xpert can be integrated with Oracle applications and PeopleSoft to help quickly identify users or applications associated with bad SQL statements, and can connect to multiple databases simultaneously to capture bad SQL statements from a production environment and test and optimize them in the development environment. Then go back to the production environment to validate it; powerful comparison features enable you to optimize SQL statement syntax, result sets, interpretation plans, and execution data in a graphical environment.

Figure: Sqlab Xpert provides comparison results for different ways of writing SQL statements
Sqlab Xpert can graphically display statements in the current shared SQL region to understand the distribution and execution of activities, or to interpret different statements. Statement logging and data collection functions can be performed in real time or on a regular basis, and can be defined to filter the data.

System Requirements:
1) Windows 98, nt/2000.
2 Connect to Oracle7.3.4, 8.0.6, 8.1.7, 9.0.1, 9.2.0 database via Sql*net.

2.5. Knowledge Xpert®for Pl/sql
Knowledge Xpert®for Pl/sql is a powerful windows-based technology resource base that covers the entire lifecycle of Oracle Pl/sql Development, and thousands of topics provide the background information, best experience, and procedural examples needed to write high-quality code. Provides thousands of topics covering the entire lifecycle of Pl/sql programming, from basic topics to advanced pl/sql coding techniques. Developed by industry experts including Mike Ault, Steven Feuerstein, Hugo Toledo, etc. Provides a powerful code base, including more than 1,000 pre-designed pl/sql procedures and functions, to reduce the amount of development time. Overlay multiple Versions (Oracle 7.3-9i) without having to query different manuals for answers. Rapid Oracle feedback that allows users to easily query over 25,000 error messages for different Oracle versions, including Oracle 9i. Seamless integration with toad® and SQL navigator® allows users to identify problems and solutions at any time. Knowledge Xpert for Pl/sql provides developers with the quickest way to write high-quality code.

2.6. Knowledge Xpert®for Oracle Administration
Knowledge Xpert®for Oracle Administration is a powerful windows-based technology repository that covers all the information needed for day-to-day management of the DBA. Thousands of topics include in-depth interpretation of concepts, database analysis information, and examples of how DBAs conduct problem diagnoses and implement solutions. Quick access to thousands of Oracle database technology topics. Cover all of the day-to-day management work of the DBA. Developed by industry experts including Mike Ault, Steven Feuerstein, Hugo Toledo, etc. Rapid Oracle feedback that allows users to easily query over 25,000 error messages for different Oracle versions, including Oracle 9i. The online database analysis feature enables you to perform health checks on the database and provide customized expert advice when the problem occurs. With instantscripts, you can access 218 scripts for database management, backup recovery, and optimization. Seamless integration with toad® and SQL navigator® allows users to identify problems and solutions at any time. and DBA pipeline--a free technology group site integration. Custom functionality enables users to add annotations, documents, and Web sites to any topic.

Knowledge Xpert for Oracle administration is a necessary tool for DBAs to find the required technical information 1th and save a lot of time.

2.7. Qdesigner
Qdesigner® is a database design and application development tool, integrated in the same product-oriented, concept and physical data object modeling functions, intuitive user interface, more than 30 kinds of database support and unique solutions to accelerate the software design and analysis process, Help designers and developers quickly submit complex distributed applications.
Whether designing new applications or upgrading existing systems, Qdesigner can significantly improve the efficiency of the people involved and improve collaboration among development teams.
1 Data modeling: The database model can be generated by modeling the two-level (conceptual and physical) relational database based on the mature methodology.
2 Object Modeling: It can be analyzed and designed through the standard by using the order and class diagram.

Define user requirements by using a scenario diagram, or by associating related business logic with an abstract data model in an entity diagram with a conceptual data model. The system environment and expected behavior are described by using the scene diagram and the sequence diagram. Generate class diagrams and special data models from metadata by adding more detail to the usage stories and sequential diagrams, deepening the design cycle.
1 Create a physical database automatically from the design model.
2 graphical interface and reverse engineering capabilities allow users to understand the existing database design.
3 by dragging and dropping, it is easy to update the existing database and realize the automation of the database change process.
4 The object-oriented model can be established to define the application structure and business logic with the standard class, as well as the sequential graph.

Figure: Modeling design using Qdesigner

2.8. Benchmark Factory
Benchmark Factory is a highly scalable, enhanced test, capacity planning, and performance optimization tool that can simulate thousands of of users accessing databases, files, Internet, and messaging servers in the application system, making it easier to determine system capacity and identify system bottlenecks, Isolate problems associated with system strength in a user's distributed computing environment. Benchmark Factory is a mature, reliable, highly scalable, and easy-to-use test tool, whether it is a server or a server cluster.
Recording and playback system strength, conducting thorough testing:
Determining the capacity and performance of a Web server is important to the enterprise. Benchmark Factory enables IT professionals to perform this task more easily by recording and replaying the transaction processes in multiuser testing. A powerful scripting engine for user processes, real latency, and benchmark factory, the thoroughness and simplicity of the combined-hardening test has reached an unprecedented new level.

Figure: Simulate and display thousands of active users in a single graphical interface
Ease of Use:
With intuitive interfaces, IT pros can easily implement hardening tests without the need for programming skills. With a comprehensive Use wizard, new users can complete hardening testing, benchmarking, capacity planning, and performance optimization, as well as information about system configuration and result analysis.
Full Extensible Architecture:
Benchmark Factory can be horizontal (Benchmark Factory's main user interface, Visual control Center, which supports hundreds of workstations running its agent software) and portrait (each agent can simulate hundreds of or thousands of users) extension. This architecture allows users to simulate the maximum number of users with minimal hardware configuration.
Performance test:
Benchmark Factory can test the performance of server clusters. Hardware vendors can use benchmark Factory to achieve failback in a timely manner and test the performance of the system before and after the recovery. Similarly, software vendors use benchmark Factory to optimize their server software to run in a clustered environment. End users can leverage benchmark factory to determine the hardware requirements of their server clusters, ensuring that sufficient performance levels are reached during the recovery process, enabling systems across different hardware and software platforms to comply with a high level of service-level agreement.
Simulate real-world scenarios:
Although benchmark Factory can test the strength of the system through the largest volume of transactions, IT professionals are more often required to adopt more realistic transactions. Benchmark Factory three ways to adjust the volume of a test:
1 input time allows the user to set the delay time before the transaction is executed, thus simulating activities such as user input data before the transaction occurs.
2 thinking time after the transaction execution, set the delay, simulate the user before entering the next step to make a decision process.
3 The execution interval sets the delay variable after the transaction is executed in order to obtain the expected stable transaction duration. With this setting, people can ensure that the system receives transaction transactions continuously and stably. Trading volume varies with the strength of the transaction until the maximum throughput is reached.
The Benchmark Factory includes a series of industry-standard benchmarking tests that can be used to facilitate testing of databases, the Internet, messaging servers, files, or application servers. The existing benchmark tests include Tpc-b, Tpc-c, tpc-d, WebStone, @Bench and other tests.
Performance Analysis and report:
Benchmark Factory provides IT staff with different methods of testing results analysis. Users can compare multiple tests, or dig deeper into the details of a test. In addition to analytics, you can print more comprehensive reports that enable users to easily master a large amount of information through Easy-to-read graphics and tables.

Figure: Mining features enable fast and easy data analysis
Integrated performance monitoring:
Quest software products can quickly test databases, file servers, e-mail servers, and web-based server applications to ensure that users have access to highly available application systems. For example, Benchmark Factory can be used in conjunction with Quest's application monitoring product foglight® to complete a variety of benchmarking tests to detect, diagnose, and resolve system bottlenecks, performance degradation, and application defects before application is put into use.

Figure: Benchmark factory users to simulate the use of users, foglight monitoring and reporting of problems detected in the enterprise
Virtual simulation to test bandwidth:
Benchmark Factory, for the first time in the hardening testing tool, implemented the ability to simulate a large number of users with a single workstation, as well as the definition of complex user event execution order. Through user processes, virtual users can perform various operations like users in real-world environments. Different virtual users can engage in different activities, such as shopping through e-commerce sites, the completion of data entry, or Sales report analysis. This simulation is critical to determining performance issues in the system before it is applied to the production environment. In addition, you can create hundreds of different user processes through multiuser testing without having to write complex test scripts.
Advanced Scripting:
Sometimes, benchmark testers need to use random transaction processing to fully validate their systems. For example, a tester might need to take different random data, either as a parameter to a database store program or as an input field for a Web form. Using the powerful scripting engine of benchmark factory, this random value process is simple enough to simulate various data types (integer, floating-point, text, and so on). or transaction type (database, Internet, message, or file).
Original Vendor Driver Support:
Benchmark Factory is available through ODBC and the original vendor-driven protocol (Oracle, SQL Server, DB2, Sybase,exchange,mapi,smtp,pop3,imap4,http,https, and FTP) Test using a generic interface.