Reprinted, the author is not detailed
Chapter 1 Program
TOAD (Tools of Oracle Application Developers) is a professional, graphical tool PL / SQL development tool to help developers and DBA effectively complete their work. It is a powerful, low-load development tool, integrated model browsing, SQL programming, PL / SQL development and debugging, DBA management, SQL statement optimization and other functions. Its biggest feature is simple and easy, and the accesses are fast. With TOAD, we can quickly access the database through a graphical user interface, complete complex SQL and PL / SQL code editing and testing work. Toad is designed for developers, is a powerful, compact professional PL / SQL development environment. Figure 1 Graphical Interface TOAD includes basic modules and optional modules, each module separately, users can choose the most suitable product according to their own development and management requirements.
Chapter 2 Basic Module
The Toad Basic Module provides the following main features: Advanced SQL Editor, edit, run, and adjust the SQL statement. Toad includes numerous features to increase the extent of productization of developers to write SQL statements. For example, simply generate a code template, automatically discover the contents and columns of the package before writing SQL, and the like. The SQL editor includes an editing window and a run results window that allows developers to test run results during editing. The SQL editor includes not only a standard editing command, but also some enhanced features, such as the fields in the fast query table, formatting the contents of the SQL statement, and more. This window can handle the contents of large to 4GB, which is very useful for large development projects. Convenient bookmarks allow developers to find relevant locations very easily. User-defined configuration features can be provided in the Run Results window, support the long and long RAW columns, you can remove data to disk, print data, editing data, etc. Stored Process Editor, used to edit, compile, test, debug stored procedures, and triggers. Toad provides grammatical identity, error identification, and many other easy-to-use features, such as displaying a table name, column name, and Oracle function in a popup window. Unlike other PL / SQL editing tools, TOAD allows multiple database objects to be operated in a file, you can compile multiple objects, compile multiple objects, compile them to the current cursor, start compiling from the cursor. When an error is running, the stored procedure stops to a problematic statement. Users can use shortcuts or templates to quickly write PL / SQL, or generate their own templates as needed. Using Toad can be easily edited, you can set a bookmark, cancel your comment, format SQL statement, and so on. Mode Browse, let us quickly access the data dictionary, browse the tables, indexes, and stored procedures in the database. Toad provides quick access to the database, is extremely convenient to use, the user interface is simple, and the structure is reasonable. When we click on a separate database object, Toad immediately displays the details of this object. For example, when we point a database, all and this table related index, constraints, stored procedures, SQL statements, and mutual reference relationships with other tables are displayed on the same interface. To simplify the operation, the user can operate the database object in the browsing window. SQL Modeler can help developers easily write a variety of complex SQL statements, just drag the mouse by simple dragging the mouse, you can write a complex query. Server and session statistics, including calculated statistics and tuning HINTS to help quickly learn about the server environment. Chapter 3 Optional Modules In addition to the basic modules, TOAD also provides the following optional modules to help complete different features. 3.1 DBA ModuledBa Module provides a simple and complete environment of DBA management, enabling authorized developers to master some of the usual management tasks, such as fast understanding of Schemas, spatial management, modify user permissions, generate Schema scripts, modify NLS (National Language Support) Parameters, etc., all of which include on the interface of Toad; DBA Module performs data importance (import) and export (export) via a graphical interface, making data loading and unloading simple and efficient At the same time, DBA Module provides establishment, modification, and deletes the functions of all DBA managed objects by simple and easy-to-use Schema Browser interfaces. 3.2 Formatter Plusformatter Plus is a powerful, flexible formatting and analysis tool. It supports PL / SQL, SQL, and SQL * Plus applications. The entire application or a single file can be immediately formatted, and the format check can be made, and the code correctness, maintainability, readability, efficiency, and configuration of the program can be optimally suggested. Thereby increasing the maintenanceability of the code, increasing the performance of the application system. Reduce the chances of app errors and improve the efficiency of application development.
3.3 PL / SQL DEBUGGERTOAD provides a simple and easy-to-use PL / SQL debugging capabilities that saves developers to develop and test valuable times in large projects to improve application development. During the development of stored procedures, Toad can be edited, debug, and run code line by line. When the runtime can enter the parameters as needed, observe the changes in the relevant parameters to check the correctness of the stored procedure. During the adjustment process, the TOAD can display all breakpoints, parameters, call stacks, and output parameters through the window. With TOAD, it is very easy to detect errors for stored procedures. Developers can run the PL / SQL statement step by step to identify problems. Debugging sessions can be carried out simultaneously with other program sessions. 3.4 Xpert Tuningsqlab Xpert is a powerful SQL tuning tool, built-in Oracle expert, SQL optimized experience library, which can quickly discover and optimize poor SQL statements to achieve high efficiency database tuning. SQLAB? Xpert can quickly find database, index, mode, and SQL statement performance issues, and propose optimized suggestions or to automatically rewrite SQL statements. Advanced Temperature Laborators can compare different optimization schemes in debugging and production environment, combined with interactive, quantized performance analysis and superior graphic high efficiency completion optimization. SQLAB? Xpert integrates a Windows interface, context-sensitive SQL optimization environment, and Oracle's famous expert's multi-year experience accumulation functions, you can identify and optimize adverse SQL statements and index mode, eliminate I / O bottlenecks. Finding and optimization of all SQL statements can be completed in the tuning laboratory with Oracle SQL. Figure 2 Discovering the SQLAB XPERT Discovery SQLAB? Xpert can monitor the activities of the SQL statement to find bad statements for different user processes and objects, and explain and optimize. Since there is no need to access the application code, it can be tested for a set application, or you can test your own development. Figure 3 SQLAB XPERT Tuning Labs SQLAB Xpert can integrate with Oracle applications and help quickly find users or applications related to bad SQL statements; connect to multiple databases simultaneously to capture bad SQL statements from production environments. In the development environment, it is tested and optimized, and then returns to the production environment to verify it; the powerful comparison function can achieve SQL statement syntax, result set, interpretation plan, and execution data in the graphical environment. Figure 4 SQLAB Xpert provides SQL statements Different WITERS SETELS SQLAB Xpert can display statements in the current shared SQL area to understand the activity distribution and execution, or interpret different statements. Statement records and data collection functions can be performed automatically or periodically, and different rules can be defined to filter data. System requirements: ● Windows 98, NT / 2000. ● Connect to Oracle7.3.4, 8.0.6, 8.1.7, 9.0.1, 9.2.0 database via SQL * NET. 3.5 Knowledge Xpert? For PL / SQL KNOWEDGE XPERT? For PL / SQL is a powerful Windows-based technical repository that covers the entire life cycle of Oracle PL / SQL development, and thousands of topics are required to write high quality code. Background information, the best experience and program example. ● Provide thousands of topics, cover the entire life cycle of PL / SQL programming, from basic topic to advanced PL / SQL encoding technology. ● Develop 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, reducing a large number of development time.
● Cover multiple versions (Oracle 7.3 - 9i), do not query different manuals to get answers. ● Fast Oracle feedback information, user can easily query more than 25,000 error messages of different Oracle versions (including Oracle 9i). ● Seamless integration with toad? And SQL Navigator • Enable users to find problems and solutions at any time. Knowledge Xpert for PL / SQL provides developers with the fastest ways to write high quality code. 3.6 Knowledge Xpert? For Oracle AdministrationKnowledge Xpert? For Oracle Administration is a powerful Windows-based technical repository that covers all information you need for DBA daily management. Thousands of topics include in-depth interpretation of the concept, database analysis information and DBA perform examples of problem diagnosis and implementation solutions. ● Quickly access thousands of Oracle database technology topics. Cover all the contents of DBA daily management work. ● Develop industry experts including Mike Ault, Steven Feuerstein, Hugo Toledo, etc. ● Fast Oracle feedback information, user can easily query more than 25,000 error messages of different Oracle versions (including Oracle 9i). ● The "Online Database Analysis" function can perform health checks on the database, and provide customized expert advice when the problem occurs. ● You can access 218 scripts through InstantScripts to perform database management, backup recovery, and optimization. ● Seamless integration with toad? And SQL Navigator • Enable users to find problems and solutions at any time. ● And DBA Pipeline - a free technical group website integration. ● Customization enables users to add annotations, documents, and Web sites to any topic. Knowledge Xpert for Oracle Administration is a required tool for DBA, you can find the technical information you need, save a lot of time. 3.7 QDesignerQDesigner? It is a database design and application development tool that integrates functional, intuitive user interface, more than 30 database support and unique solutions to the same product. Design and analysis process, helping designers and developers quickly submit complex distributed applications. Whether it is a new application, or upgrade the existing system, QDesigner can greatly improve the work efficiency of relevant personnel and improve the cooperation between the development group. ● Data modeling: QDesigner can generate database modes by modeling dual-level (conceptual and physical) relational database based on mature methodology. ● Object Modeling: QDesigner can use case, order and class chart, and analyze and design by standard UML. From the class chart, QDesigner can automatically generate or reversely generate code for Java?, XML, C , PowerBuilder? And Visual Basic? And other target languages. QDesigner can automatically generate code applications for popular programming languages from class charts, including Java, PowerBuilder, XML, C , and Visual Basic. Users can generate functions in QDesigner, generate consistent models for their application systems, and even physical database objects corresponding to class charts. QDesigner can also reverse the Java, PowerBuilder, and XML code to achieve high efficiency bidirectional projects. QDesigner provides specifications and easy-to-use modeling methods that capture business rules, business processes, and specific needs. The business needs of the analysis phase record can trigger application development and database design. QDesigner MetaWorks? Enterprise libraries provide global views of all requirements analysis and metadata required to manage successful project implementation.
At the same time, it is possible to easily generate a report of the Web or standard Word format for multiple models, thereby issuing related information to any person who needs to understand the project progression. Define user needs with the abstract data model by using a scene chart or in an entity relationship with a conceptual data model. Describe the system environment and expected behavior by using scenarios and sequential diagrams. Deepen design cycles, generate classes and special data models from metadata by adding more details to use scenarios and sequential charts. ● Automatically create physical databases from the design model. ● The graphical interface and reverse engineering functions allow users to understand existing database design. ● The existing database is easily updated by dragging how to update the existing database and automate the database change process. ● MetaWorks? Module can achieve enterprise repository, allow multiple users (developers, analysts, designers) to achieve synchronous and collaboration in work. ● The object-oriented mode can be established to define the application structure and business logic, and sequential charts in standard UML classes. Figure 5 Modeling Design System Requirements with QDesigner: ● Agent: Windows 98/2000 or NT 4.0; ODBC Connection; SVGA Display; CD-ROM Drive; 60MB Available Disk Spaces. ● MetaWorks: Mainstream database with ODBC: Sybase, Microsoft, Informix, Oracle, or DB2. 3.8 Benchmark FactoryBenchmark Factory is a highly scalable intensive test, capacity planning, and performance optimization tool that simulates thousands of users to access databases, files, Internet, and messaging servers in the application system, making more convenient determining system capacity, find The system bottleneck, isolating the problem of system intensity in the distributed computing environment of the user. Whether it is a server or a server cluster, Benchmark Factory is a mature, reliable, high scalability, and easy-to-use test tool. Record and playback system strength, thorough testing: Determine the capacity and performance of the web server is very important to companies. Benchmark Factory enables IT professionals to complete this task more conveniently by recording and playing back the transaction process in multi-user testing. The powerful script engine of user processes, real latency, and Benchmark Factory, the thoroughness and simpleness of combined testing have reached an unprecedented level. Figure 6 simulates and displays thousands of active users in a single graphical interface: IT professionals can easily implement the reinforcement test without programming skills. New users can complete the intensive test, benchmark, capacity planning and performance optimization, and obtain information about system configuration and results analysis. Fully scalable architecture: Benchmark Factory enables horizontal (Benchmark Factory, Visual Control Center, can support hundreds of workstations to run their agent software) and portrait (each agent can simulate hundreds or thousands of users) Expand. This architecture allows users to simulate the maximum number of users at the lowest hardware configuration. Performance Test: Benchmark Factory can test the performance of the server cluster. Hardware vendors can use Benchmark Factory to make failed recovery in a timely manner, and test the performance of the system before and after failure recovery. Similarly, software vendors use Benchmark Factory to optimize their server software to run in a cluster environment. End users can use Benchmark Factory to determine the hardware requirements of their server clusters, ensuring that sufficient performance levels are reached during the fault recovery process, so that systems across different hardware platforms can comply with high-level service-class protocols.
Simulation reality scenario: Although Benchmark Factory can pass the largest transaction volume, the strength of the test system; in most cases, IT professionals need more real trading volume. Benchmark Factory Adjusts the amount of transactions in the test in three ways: ● Entering time allows the user to set the delay time before transaction execution, thereby simulating activities such as user input data before transaction. ● Think Time Sets the delay after the transaction is executed, and the simulation user makes decisions before entering the next step. ● Intermittent Time Sets the delay variable after the transaction is executed to obtain the expected stable transaction. When using this setting, IT staff can ensure that the system continuously receives trading transactions. The trading volume changes with the intensity of transactions until the maximum throughput is reached. Benchmark Factory includes a series of industry-standard benchmarks that can be used to easily test databases, Internet, message servers, files, or application servers. Existing benchmarks include TPC-B, TPC-C, TPC-D, WebStone, @ Bench, and other tests. Performance Analysis and Report: Benchmark Factory provides IT staff with different test results analysis methods. Users can compare more than multiple tests or further excavate the details of a test. In addition to the analysis function, you can print more comprehensive reports, allowing users to make a lot of information through easy reading graphics and tables. Figure 7 Mining function can quickly and easily perform data analysis integrated performance monitoring: Quest Software products can quickly test databases, file servers, email servers, and web-based server applications to ensure users with high availability. For example, Benchmark Factory can monitor the product FOGLIGHT? Combined with QUEST's application, complete a variety of reference tests, resulting in problems such as pre-application, detection, diagnosis, and solve system bottlenecks, performance reduction and application defects before application investment. Figure 8 Benchmark Factory User Simulates User's Use, Foglight monitors and reports problems detected in the company to test bandwidth: Benchmark Factory first enhanced test tools simultaneously with a single workstation to simulate a large number of users, and complex User event executes the definition function of the order. Through user processes, virtual users can complete various operations like users in a real environment. Different virtual users can engage in different activities, such as shopping through e-commerce websites, completing data entry, or analyzing sales reports. This simulation is critical to determining the performance issues in the system before the application is used. In addition, hundreds of different user processes can be created by multi-user testing without having to write complex test scripts. Advanced scripts: Sometimes, benchmarks need to use random transaction processing to fully verify their system. For example, testers may need to use different random data, as a parameter or input field of the data set, or a web form. With the powerful scripting engine of Benchmark Factory, this random access process is very simple, you can simulate a variety of data types (integer, floating point, text, etc.) or transaction types (database, Internet, messages or files). Original Driver Support: Benchmark Factory uses the general interface to test through ODBC and original manufacturers (Oracle, SQL Server, DB2, Sybase, Exchange, MAPI, SMTP, POP3, IMAP4, HTTP, HTTPS, and FTP).
