Toad for Oracle Visual Management tools for Oracle database use

Toad for Oracle installation package: Http://pan.baidu.com/s/1mgBOLZU

Accessing database objects and writing SQL programs is a tedious and time-consuming task in the development of Oracle applications, and it takes a lot of SQL scripts to manage the database on a daily basis. Quest Software provides an efficient Oracle Application development tool-TOAD (Tools of Oracle Application developers) for this purpose. in the new version of Toad, the DBA (Database Administrator DB Administrator) module has been added to help DBAs with many of the day-to-date management tasks. its greatest feature is ease of use and fast access . With Toad, we can quickly access the database through a graphical user interface to complete complex SQL and PL/SQL code editing and testing work. Designed specifically for developers by Oracle development experts, Toad is a powerful, compact, and specialized PL/SQL development environment.

Toad mainly has the following characteristics:
Schema Browser (schema browser):
Mode browsing provides quick access to data dictionaries, browsing tables, indexes, and stored procedures in a database. Toad provides quick access to the database, extremely convenient to use, simple user interface and reasonable structure. When we click on a separate database object, Toad immediately displays the details of this object. For example, when we point to a table of a database, all indexes, constraints, stored procedures, SQL statements, and other tables related to this table are displayed on the same interface. To simplify the operation, the user can manipulate all database objects in a modal browser window.

(Figure Schema Browser display all database objects in "Multi line Tab")

SQL Editor:
The main function of the SQL Editor is to edit, run, and adjust SQL phrases. TOAD's advanced editing window includes numerous features to increase the degree to which developers write SQL statements. For example, simply generate a code template that automatically discovers 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 the developer to test the results of the run during the editing process. The SQL Editor includes not only standard editing commands, but also enhanced features such as quick querying of fields in a table, formatting the contents of SQL statements , and so on. This window can handle up to 4GB of content and is useful for large development projects . Convenient bookmarks make it easy for developers to find relevant locations. The Run Results window provides user-defined configuration capabilities , supports long and long raw columns, and can offload data to disk, print data, edit data, and more.

(Figure in the SQL Editor select part of the SQL code snippet to execute)

Stored Procedure Editor (Procedure editor):
The main functions of the stored procedure editor are editing, compiling, testing, debugging stored procedures, and triggers . Toad provides syntax identification, error identification, and many other easy-to-use features, such as displaying table names, column names, and Oracle functions in a pop-up window. 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 start compiling from the cursor . When an error occurs running, the stored procedure stops to the problematic statement. users can use shortcuts or templates to quickly write PL/sql, or they can generate their own templates as needed. you can use Toad to make editing work easy, such as setting bookmarks, canceling comments, formatting SQL statements, and so on.

(figure: In the stored procedure editor, prepare to tune the SQL fragment into SQL Tunning)

SQL modularity (SQL Modeler):

SQL Modeler is a graphical SQL statement generation tool that allows developers to easily generate complex multi-table query SQL statements with the help of a mouse drag.

(Figure: Write a complex SQL script with the mouse "Drag & Drop")

Fastreport Report Designer:

Fastreport is the industry-renowned reporting engine, Toad embedded in the fastreport, so that it has the ability to dynamically generate customized reports, Fastreport is extremely powerful, you can customize the Report Wizard, generate pie chart, bar chart, line chart, table and other forms of presentation, The resulting results can be exported to pdf,html,jpg,bmp in various formats.

(Report Designer for figure Fastreport)

Script Manager:

With Script Manager, you can centrally manage common SQL scripts. The following work can also be done:
?? Organize your scripts into categories
?? Convenient script Query
?? Executing scripts on multiple databases
?? Execute multiple scripts at once
?? Execute multiple scripts at one time on multiple databases

Master-Slave Table browser (master/detail Browser)

Use Master/dtail Browser to simultaneously browse and edit multiple tables, views, snapshots, or queries that are connected by a foreign key connection or a user-defined connection. For example, we can define department as the master table, the employee table as the detail table, and the two tables to be related by department_id. The data displayed by the employee table will change with the current cursor of the Department table.
The report Engine Fastreport in Toad can be tied to the configuration of master and slave tables to make a master/slave form of the report.

Color definition connection (Connection color-coding):

Toad allows multiple databases to be connected at the same time, enabling switching and alignment between multiple databases. However, this also increases the risk of mis-operation on the database. Connection color-coding allows the user to specify a color for the connection when defining a new database connection, so as to be a prominent reminder.

(Figure custom to represent the connection between the production library and the test library in red and green colors respectively)

PL/SQL Editor Debugger options:
Toad provides powerful, easy-to-use PL/SQL debugging capabilities that can save developers valuable time for development and testing in large projects and improve the quality of application development. During the development of a stored procedure, Toad can edit, debug, and run the code line by row . The runtime can check the correctness of the stored procedure by entering parameters as needed and observing the changes of the relevant parameters. During the mode,Toad can display all breakpoints, parameters , call stacks, and output parameters through the window. With Toad, it is very easy to detect errors in stored procedures, and developers can run the PL/SQL statement to identify the problem step-by-step. a debugging session can be performed concurrently with other program sessions.

(Figure: A powerful debug function is a tool to debug SQL)

Coding profile Analysis (code Profiling):

Profiler is a debug optimization tracking scheme for Oracle PL/SQL. You can perform performance statistics for each line of code to help evaluate performance issues with SQL statements. Because there is no need to build and read the server-side trace files, so the analysis is also relatively fast, the disadvantage is the way the command line, not easy to use. Code Profiling is the toad of the Oracle Profiler Technology Visual Packaging, the SQL statement tracking statistics, very intuitive and convenient.

(Figure Code Profiler visually displays statistics for each row)

PL/SQL Technical Documentation Resources (Knowledge xpert™for PL/SQL)

Knowledge Xpert™for PL/SQL is a powerful Windows-based technology repository that covers the entire lifecycle of Oracle PL/SQL development, and thousands of topics provide the background information, best practices, and procedural examples needed to write high-quality code.
?? Provides thousands of topics covering the entire life cycle of PL/SQL programming, from basic topics to advanced PL/SQL coding techniques.
?? Developed by industry experts including Mike Ault, Steven Feuerstein, Hugo Toledo and more.
?? Provides a powerful code base that includes over 1,000 pre-engineered PL/SQL procedures and functions, reducing the amount of development time.
?? Overwrite multiple versions (Oracle 7.3–10g) without having to query different manuals for answers.
?? Fast Oracle feedback to make it easy for users to query more than 25,000 error messages for application development solutions from different Oracle versions (including Oracle 9i).
?? Seamless integration with toad® and SQL navigator™ enables users to identify problems and solutions at any time. Knowledge Xpert for PL provides developers with the quickest way to write high-quality code.

Team coding (Teams Coding)

Toad for Oracle team Coding enables collaboration between development teams. Team coding allows multiple developers to read both source and database objects at the same time, and to prevent simultaneous rewriting of code and database objects through effective code locking. At the same time, Team Coding supports third-party version control systems, such as Merant PVCS, Microsoft SourceSafe, Rational ClearCase, and Starbase's Star Team, among many other products. For database schemas or objects under version control System (VCS) management, Toad can take source code from the VCs repository and quickly compare it to determine whether the VCS code is up-to-date, or alert the user if a new version exists on the database. Developers can rely on Toad's change management mechanism.

Code rule Validation (codes Xpert)

Codexpert can improve code quality by testing the PL/SQL code against a set of predefined best rule sets and recommending code that does not conform to the rules. In addition to toad predefined best practices, users can define their own set of rules to add.

(Figure Codexpert Check the stored procedure after the rule check, give the result of the inspection)

Sqlab Xpert option:sql optimization (SQL Optimizer)
Sqlab Xpert Option helps developers optimize SQL, provides them with SQL execution plans in a variety of optimization modes, and gives recommendations for optimization to compare actual SQL Run results in various modes . Help developers develop efficient code with real speed.

SQL Optimizer can optimize the inefficient SQL statements found by SQL Scanner and SQL Inspector. It uses built-in artificial intelligence (AI) technology to fully analyze the SQL source code, exhausting all possible SQL rewriting methods and optimizing the Oracle Database (hint), outputting a semantically equivalent, syntactically correct list of SQL statements. After testing all the SQL statements in the list, you get the SQL statement that best fits the current database environment.

(Figure: Under Level 4 optimization intelligence, SQL Optimizer gives 72 alternative SQL scenarios for current SQL)
SQL statements with optimal performance can be found by executing the original SQL statements and alternative SQL statements before tuning. Benchmark SQL Alternatives can execute the SQL statements in bulk, displaying the quantitative performance metrics of each SQL in a simple chart to help the user find the most appropriate scenario for the SQL statement.

(Figure: After a batch execution, the best solution is the Alt #4, which saves execution time compared to the original SQL 99%)

(Figure: SQL Tunning with benchmark Factory for "scalability" test to get the optimal SQL statement under concurrency conditions)

Indexing Specialist (Index expert)

Index Expert can analyze the syntax of SQL statements and the relationships between tables and tables in SQL statements, giving the best alternative index recommendations. All recommended indexes do not need to be really established on the database when performing evaluation, so there is no impact on database application.

(Figure: Index Expert gives 7 virtual index recommendations)

Index Expert-Recommended indexes can be compared by benchmark index alternatives to find out which indexes need to be permanently generated in the database.

Cross-Index analysis
Cross Index analysis can parse a set of SQL statements to find the common index of this set of SQL statements, making the new index more versatile.

(Figure: Cross-index analysis gives 6 crossed-index recommendations for the SQL Group on the right)

DBA Modules (DBA module)

The DBA Module provides a simple, well-managed DBA environment that allows authorized developers to master some of the usual administrative tasks, such as quickly understanding the schemas of a database, making space management, modifying user permissions, generating schema scripts, and modifying the NLS (National Language support) parameters and so on, all of which are intuitively included in the Toad interface; The DBA Module imports and exports data via a graphical interface that makes loading and unloading of data simple and efficient; Module provides the ability to create, modify, and delete all DBA-managed objects through an easy-to-use schema Browser interface.

(Figure: Powerful DBA function is a good helper for DBAs)

Database Monitor

Database Monitor graphically displays logical/physical IO, wait events, sessions, call rate, Miss rate, SGA usage, shared pool, index query a total of 9 databases run information. Each diagram can be enlarged and displayed. The refresh interval of the graph can be set to 15 seconds, 30 seconds, 1 minutes, 5 minutes, 10 minutes, and 15 minutes, respectively. In the case that the database Monitor interface is open, an alert message is sent as a message or a tray alarm icon if there is more than the maximum minimum threshold set in View->option->monitor.

(in Figure Monitor, the database run information is displayed as a horizontal graph)

Database Explorer (DB Probe)

The Database Probe window displays all kinds of alarm information in real time, can also be customized to define the alarm, can be regarded as a simplified version of the spotlight, if installed Spotlight, you can also call from the database Probe spotlight.

(Figure Probe is a simplified version of the spotlight (Mac OS X v10.4 A quick, on-demand, system-supported Desktop Search feature))

Database Run security check (health check)

Health Check can generate a report that includes about 50 database statistics, status, events, and more. The output is color-coded for easy browsing. You can also configure not to display normal information after all predefined checks, you can execute a user-defined script that adds the results to the report.
Each check is optional, and most of them can be configured. Results reports can be saved as html,rtf or text files and sent out via the mail system. can also be saved to the current database or other specified database. You can check multiple databases at once.
Can be executed on a command-line basis, where a user can set up a batch file to be executed periodically through a scheduled task. For example, you can set the execution in the night, the DBA in the daytime by looking at the HTML format check output file, the night database health.

(Figure Health Check checks two databases at the same time)

Routine Manager (Instance Manager):

Instance Manager is used to monitor the availability of database nodes, listeners, and databases. Record a copy of the database status change history and verbose log. You can manage the start and stop of a database. When the window is open, you can follow the configuration in "View->option->instance Manager" to send messages or flashing tray alarms.

(Figure ORCL The database is in "StartUp" state)

Advanced Session Finder:

The TOP session Finder queries the session that consumes the most resources.

(Figure shows the resource usage for each session with a pie chart)

Parameter list (Oracle Parameters)

The list displays the data in the database view V$parameter. You can modify the database parameters by double-clicking to change the selected parameters and issuing the "alter system" or "alter session" command by Toad. Supports RAC form.

Conversation Browser (Session Browser)
View the database session lock, long operation and other information. Sessions can be tracked or killed.

Toad can also plug some other products, such as pl/formatter, revealnet knowledge Base, SQL impact, and so on, these can be tightly integrated with Toad, together provide a perfect integrated development environment. To help you fully test your application, Quest software provides you with a Benchmark factory―― a load-pressure test solution that simulates thousands of users in real-world situations accessing your application. By knowing in advance the application performance of the application system in the case of overload, you can locate and solve the performance problems and scalability problems before going online.

Use benchmark Factory for Database:
?? The maximum throughput and processing power of the database system can be learned.
?? Using a small amount of hardware resources, you can simulate thousands of concurrent users.
?? Find out the unbalanced load points that the application system appears to increase with the user.
?? Find the system performance inflection point, weak cohesion points and bottlenecks.
Application Development Solutions:
?? Quantify the performance metrics of applications and service periods
Benchmark Factory During the testing process, a large amount of statistical data is collected, including server throughput (measured in transactions per second, Bytes/sec, etc.) and transaction statistics generated by each load-carrying test station, and all test results are collected and stored in the database for measurement, Analyze and predict the capacity of the system.
Benchmark Factory can also be integrated with the products of other quest software companies to quickly measure system processing power and performance in the IT department to optimize the system and reduce User Service response times. For example, Benchmark and Spotlight together, generated by the Benchmark concurrent load, by spotlight detection and diagnosis problems, before the system application online, to find the system bottleneck, inefficient causes and application defects.

(Figure Benchmark Operating mechanism)

In addition, the Quest software provides a lightweight client test data generation tool ――datafactorythat enables development and QA engineers to easily and quickly populate the test database with reference-relational table data for testing. Test data can be quickly generated and loaded into the database.
After specifying the database table columns and the number of records that need to be generated, DataFactory can produce test data in the following three ways.
?? Generating synthetic data
?? Copy or calculate data from an existing data source, such as another database table or flat file
?? Generate real data using built-in data generation libraries

--------------------------------------------

Attached:  DBA (database administrator)  
  dba is the database administrator. Administrator.
Some of the responsibilities of   DBA:
      Installing and upgrading database servers (such as Oracle, Microsoft SQL Server), and application tools. The
      database designs System storage scenarios and develops future storage requirements plans.
      Once a developer has designed an application, the DBA is required to create the database storage structure (tablespaces).
      Once a developer has designed an application, the DBA is required to create the database object (tables,views,indexes).
      Modify the structure of the database, if necessary, based on feedback from the developer.
      The user registering the database, maintaining the security of the database.
      Ensure that the database is used in compliance with intellectual property laws.
      control and monitor user access to the database.
      Monitor and optimize the performance of your database.
      make a database backup plan, recover database information when a disaster occurs
      maintain archiving on appropriate media or back up data
      back up and restore databases
      Contact the manufacturer of the database system to track technical information