TOAD Quick Guide

General Shortcuts
Schema Browser Window
Using Favorites
Procedure Editor and Debugger
SQL Editor Window
Data Subset Wizard
Using Auto Replace
Project Manager Tutorial
Action Palette or Application Designer (Save repetitive actions like a macro)
Action Console
Object and Schema Compare
Statspack and AWR Browser
Data Import / Export Browse
Trace File Browser
Code Expert
Database Browser
RMAN Script Templates
Data Generation
Rebuild Multiple Objects
SGA Trace Optimization
Tuning SQL (Optimize SQL)
Run TOAD on a USB Drive
Other Good Tools
Resources Collected
Download....

Toad for Oracle Editions 
As you may already know, there are different editions of Toad for Oracle:
 

Does Toad need OEM ?
Toad offers optional features in the DB Admin Module (under Database/Monitor) which WILL ACCESS the Oracle OEM Diagnostics Pack such as :
  1. ADDM/AWR Report Generator – enables snapshot management and shows both AWR and ASH reports
  2. AWR Browser – graphical representation of data collected from AWR
  3. ASM Manager – enables management of ASM disk groups and clients
Toad does offer alternate ways to determine performance bottlenecks without the use of ADDM/AWR such as the StatsPack Browser, TK Prof interface, Database Monitor, Session Browser and the Quest SQL Optimizer’s SQL Inspector to name a few. However, if you are already licensed to use the OEM Diagnostics Pack and you wish to get additional value from it, you can use the functionality we offer in Toad.
If you are on Oracle database 10g and above, you can use the Oracle Tuning Advisor feature in Toad Base (9.6 and higher) which WILL access both the Oracle OEM Tuning Pack and Diagnostics Pack.
Alternatively, you could use Toad Xpert, Development Suite or DBA Suite Editions and use the Quest SQL Optimizer which DOES NOT access any of the Oracle OEM Packs at all. In addition, Quest SQL Optimizer offers a unique way to rewrite your SQL code for maximum performance.


TOAD DB Module

Screen Shots of its content:

Database - Administer - Compare and Import Options


Database - Optimize - Diagnose - Monitor Options



General ShortCuts
ACTION KEY
Schema Browser F2
SQL Editor F3
Describe an Object (also CTRL+Rigth Click). Just  put the cursor over the object
 F4
Execute code as Script (from SQL Editor) F5
Jump to that Object (Browser Window) SHIFT + F4
Toggle between SQL Editor and Results tabs F6
Clear all text (from SQL Editor) or Trace Into on the Procedure Editor F7
ReCall SQL History (opens the SQL Statement Recall panel)
 F8
Display Previous/Next Statement used ALT + Up or Dn
Provides a Code Template  (with Rigth Click - Editing Options - Code Templates I can edit them) CRTL + Space
Run Statement (from SQL Editor) or Compile (on the Procedure Editor). Execute all statements in the Editor F9
Verify statement without execution (parse) CTRL + F9
Run Statement at Cursor SHIFT + F9
Execute as script or Run (continue execution) in the Procedure Editor for PL/SQL debugging F11
Run to cursor in the Procedure Editor for PL/SQL debugging. F12
Convert Text to Lowercase / Uppercase
 CTRL +  L / U
In the data grids, goes to the TOP/END of the recordset CTRL + HOME or END
Clicking on a procedure/function name while holding the <CTRL> key takes you to the place where that name is defined. <CTRL>Click on identifier
Moves to the selected procedure in the body from the spec (up or down)
 CTRL + SHIFT + UP or DOWN
Completion dropdown. As you type the procedure name, the dropdown does an incremental search in the list. CTRL .
If you begin a procedure call and pause after the first (, Toad parses the procedure spec and gives you parameter hints. You can cycle through parameters for overloaded functions. (
Execute Explain Plan on the Current Statement  CTRL + E
Recall Named SQL Statement CTRL +  N
Columns Dropdown  CTRL + T
Navigate to the next results panel tab CTRL + ALT <PageDOWN>
In the data grids, goes to the top  / End of the recordset CTRL + HOME or END
Completely expand dependency tree views CTRL + SPACE

 
Schema Browser Window
The Schema Browser is your gateway to the database objects in your Oracle instance. Simply select the user/schema, database object type, and database object, then immediately gain access to all the pertinent information for that object. For each object you can generate its DDL, see Used BY, check stats, indexes, constraints, etc

For Table Data you can:
•  Create Insert for All Rows
•  Create Insert statements replacing values (example use sysdate for dates, sequences, etc)
•  Save as HTML Report
•  Generate very nice reports
•  Detect Duplicate Rows
•  Record Count
•  Perform Multi-Select and then work with those rows only
•  Find Data
•  View/Edit Query
•  Create in Another Schema
•  Compare Data
•  Rebuild Objects
•  Master/Detail Report

For Code
CodeXpert to provide Tuning in your code

Customize Left Hand Side (LHS)Tabs
Customize tabular view by Right clicking in the white area of the object icon bar and selecting the configure box. Double click on the box intersecting the Tab you would like to hide and the box that reads “VISABLE.”
Captions can be modified to display a user-defined description in the tab. Or if English isn‟t your first language, translate “Tables” to “Les Tables” (yes, this is a joke.)
Use the 'Up' & 'Down' arrow buttons to re-order the tabs, or use the 'Alphabetize' button to make items easier to find, versus 'Tables' and 'Views; appearing first and second respectively.

History
Quickly navigate to objects you've browsed to previously. Use the "Sundial" button.

Data
View and modify a table's data by selecting table from the object tabular view, and the DATA from the right side of the screen
a) Sort/Filter the data by selecting the icon resembling a funnel
b) Select Columns- to limit the columns shown in the grid right click and choose SELECT COLUMNS
c) Save the data to a file format of your choice by right clicking in the data grid and selecting Save As. This gives the choice of format and saving the data to a file or copying to the clipboard.
d) Create Insert Statements by right clicking the data grid and selecting create insert statement. It will save inserts on clipboard to be run from Editor.
e) Customiz Layouts by dragging and dropping columns into select order. Fix a column or set of columns by right clicking and selecting fix current column. View only desired columns by right clicking and choosing select columns. To save a desired layout, select VIEW>OPTIONS>SCHEMA BROWSER> DATA and GRIDS>DATA GRIDS and check "Save Layouts"
f) Reporting- To access TOAD's Fast Report reporting tool, right click in the Data Grid and select "Report". You will find a report generation wizard to walk you through report creation. You can also access this via the "Grid" Toad menu item, e.g. GRID>Report.



Using Favorites as a Custom Schema Browser
Often in TOAD, you need to work with the same group or groups of objects. For example, you might only need to routinely work with the production tables for CUSTOMER and EMPLOYEE, their indexes and views. So you would like to have a customized Schema Browser for just those objects. TOAD offers the Favorites tab so that you can easily and quickly work in this manner.
It can be a huge productivity enhancer. You can group your DB objects by different folders.
Once you created your folders, you need to browse to your favorite DB object, rigth click on it and select "Add to SB Favorites List"


Procedure Editor Window and Debug Menu
First of all, some concepts:

Debugger Shortcut Keys
ACTION
 KEY
Set or Delete a Breakpoint on the current line SHIFT + F5
Add watch at cursor CTRL + F5
Trace Into SHIFT + F7
Step Over SHIFT + F8
Display mouse right-click popup menu
 F10
Trace Out SHIFT + F10
Compile F9
Execute Current Source SHIFT + F9
Set Parameters SHIFT + CTRL + F9
Run (continue execution) F11
Run to Cursor F12
Display Breakpoints
 CTRL + ALT + B
Display DBMS Output
 CTRL + ALT + D
Evaluate/Modify
 CTRL + ALT + E
Display Watches
 CTRL + ALT + W


Rigth-Click Menu

Execution Profiling
Toad allows you to record your PL/SQL execution to determine where any execution bottlenecks are occurring, e.g. „Why is my program taking so long to run?‟ To execute a profiler run, toggle "on" the "stopwatch" button next to the "debug" toggle. Then execute your PL/SQL program from the Editor. After it is finished, pull up the record from the "Profiler" tab. With version 9.6 and higher, you can now automatically pull up the visual chart representations of your PL/SQL runs by clicking on the "Details" button and quickly determine which line of code is taking the most time to run. Toggle on the ‘Details’ view to see a graphical representation




The Toolbar for Debugger


From left to right:
• The lightning bolt is the Run button. This button will execute the procedure in debug mode.
• The (...) parameter allows you to set any IN variables to the package and/or procedure.
• Next is the Step Over button, which allows you to walk through the PL/SQL code one line at a time. This button will skip any procedures that are called.
• The fourth button is the Trace Into button. Both this button and the Step Over button walk through PL/SQL code one line at a time, but Trace Into will enter any called procedures or functions and execute that code one line at a time.
• Next is the Trace Out button; it exits Trace Into code.
• The sixth button is the Run to Cursor button. This is an alternative to setting breakpoints. PL/SQL is executed until it reaches the line where the cursor is, and then halts execution much like a breakpoint.
• The hand button is the Halt Execution key, and it will stop execution of the PL/SQL routine retaining watch and breakpoint settings.
• The eyeglass button allows you to easily set watches on variables where the cursor is located.
• The final button compiles the entire procedure call tree for debugging.


Some notes on Debugger
If you have OUT or IN OUT arguments in your procedure, you can elect to view their values during debugging in the Debug DBMS Output window.
To accomplish this, check the “Output OUT Args” check box on the “Execute Procedure/Package/Trigger” dialog.
TOAD will automatically add DBMS_OUTPUT.Put_Line statements at the end of the anonymous PL/SQL block used to invoke your procedure.
Turn on the Debug DBMS Output window from the “Debug” menu, or press CTRL + ALT + D

Debugger
A developer's best friend for figuring out why your program isn't behaving as expected. Run your program line-by-line, by "stepping" through the code.



Modifying Variable Values While Debugging
To artificially change the value of one of your PL/SQL variables, highlight the variable in the watch window and hit the calculator on the icon bar which, once moused over will read “Evaluate/Modify Watch”



Setting breakpoints/visualizing variable contents
Breakpoints suspend the execution of the code. This allows you to view the contents of various variables.
You could set the breakpoint by simply clicking to the left of the Procedure Window.
Notice that the Break Points tab at the bottom shows the line location of the breakpoint. To work this code, click where the breakpoint is desired and then press the Run button. This will invoke the debugging routine and suspend code execution when the breakpoint is reached.
After the code is suspended, you can check the contents of variables and implicit cursors. The line with the breakpoint set is now highlighted in blue. Simply place the mouse cursor over a variable or cursor and the contents will pop up after a second or so.


Watches
A watch in TOAD allows you to watch the changes to variables as the code is executed. You can also change the contents of a “watched” variable. Watches are easy to set.
You can highlight the variable and press the Add Watch button on the Watch tab (the Ins key is the TOAD hot key).
You can also right-click on the highlighted variable and select Debug | Add Watch at Cursor.
Any of these options will add the variable to the Watch tab.
You can also modify the value of a variable that is watched to force a special situation.

Conditional breakpoints
TOAD allows for breakpoints to occur when the process has performed certain events (such as looping x number of times) or when a certain data condition exists.
This is easily accomplished by first setting the breakpoint. Click to the left of the Procedure Window, and then right-click and select Debug | Set Breakpoint). Then, go to the Break Points tab, highlight the breakpoint for which you want to define a condition, and press the Edit Breakpoint button (the leftmost button).



SQL Editor Window

ACTION
 KEY
Windows Help File F1
Toggle Output Window Figure F2
Toggle Data Grid Window Shift + F2
Find Next Occurrence F3
Find Previous Occurrence Shift + F3
Describe Table, View, Procedure, Function. Just  put the cursor over the object F4
Execute SQL as a script F5
Toggle between SQL Editor and Results Panel F6
Clear All Text F7
Recall Previous SQL Statement F8
Display Previous / Next Statement Alt + Up / Down
Execute Statement F9
Set Code Execution Parameters Ctrl + F9
Execute Current SQL statement at Cursor Shift + F9
Pop-up Menu F10 or right-click
External Editor, Pass Contents Ctrl + F12
Execute Explain Plan on the Current Statement Ctrl + E
Goto Line Ctrl + G
Convert Text to Lowercase Ctrl + L
Make Code Statement Ctrl + M
Recall Named SQL Statement Ctrl+N
Open a Text File Ctrl + O
Strip Code Statement Ctrl + P
Columns Drop-down (show objects owner by user)
 Ctrl + T
Alias Replacement Shift + Ctrl + R
Columns Drop-Down no alias Shift + Ctrl + T
Code Templates Ctrl + Spacebar
Converts Text to Uppercase / Lowercase
 Ctrl + U / L
Display Pop-up List of Matching Table Names Ctrl + .
Redo Last Undo Shift + Ctrl + Z
In the data grid: goes to the top  / End of the record set Ctrl + Home / End
Cycles through the Collection of MDI Child Windows Ctrl + Tab


SQL Editor Shortcuts
         1. If you have long column/table names and do not like typing them out each time, then you can use our auto complete feature. Type in a portion of the table or column name, for example “ow_cu”, and then press Cntrl + . (period). Toad will automatically identify the name of the object and fill in the rest of the word to read “ow_customers”. If there is more than one object that satisfies the string “ow_cu”, then Toad will bring up a list of all the possible objects and you can select from there.
         2. Everyone should be aware of SQL Recall Feature (F8) which brings up previously run select statements. If you want to quickly list old statements that you ran minutes ago, then in the editor press Alt + Up or Down arrow key and it will toggle through your SQL Recall list. This saves you from opening up the Recall list and scrolling down to find the SQL you want. You can keep the focus in the editor and toggle through with this hot key.
         3. If you are constantly mistyping words in the Editor, then let Toad fix your spelling errors automatically. Right click in the editor and select “Editing Options”. On this new option screen click on the “Auto Replace” button in the bottom right hand corner. Here you will see a list of the common misspelled words our user’s experience. If there are words you constantly misspell, then you can add them to the list by using the “Add” button. So, now in the editor if you mistype the word “select” as “seelct” … it will automatically fix itself once you hit the spacebar.
          4. If you keep the Ctrl key pressed and click over a procedure/package name, that code will be opened on another TAB. If you do it over a TABLE, it will desc that table.


SQL Recall
Everyone should be using SQL Recall Feature which brings up previously run select statements. Access previously executed SQL by selecting F8. This will put a “Slide in slide out” SQL recall button on the left side of the Editor. The user can filter the list by adding to “Personal SQLs” or take it a step further by adding to “Named SQL” both of which are found under the SQL Editor menu option. To select Personal and Named SQL, right click the statement and select “Change to Personal” or “Change to Named.”
a. Named SQL Giving your SQL Statements a name allows you to recall your query by context versus obscure SQL you may have wrote 6 months ago. If you spend more than 30 seconds writing a SQL statement, give it a name. You can now recall w/o using the F8 dialog giving you more room to type in the editor. Use <CNTRL>+N to popup a list of named SQL statements. Selecting one will put the SQL in your editor.
b. Quick Browse You can cycle through your list of previously written SQL statements using <ALT>+<Up Arrow> or <ALT>+<Down Arrow>. You can do this on selected text to do a limited replacement.

SQL Function Templates
From the VIEW menu select the CODE SNIPPETS this will invoke a sliding/dockable window displaying code templates. A drop down let‟s us see all of the different Function Types from which we can select templates. Drag and drop can also be utilized from this dockable window

Code Templates
You can customize the pre-written code templates by right-clicking in the Editor and choosing “Editing Options.” From there you will default into the behavior portion of the Editor options. From the Language area, choose edit, and you will see a number of templates to edit. Select Templates to see, add and edit you templates. Toad provides many templates but the user can also add their own templates from here. To access the Templates from the Editor simultaneously press <CTRL> and the Space Bar. The user can also memorize the shortcut name, type one and hit CRTL/Space to retrieve the Template.

Code Insight T
Toad can help you write your SQL and/or PL/SQL statements. Code Insight (<ctrl>+<Period> from the editor) allows you to quickly browse and select Tables, Views, Aliases, Functions. Procedures. Packages, Sequences, Users and Public Synonyms.
Code Insight can now be initiated by <CNTRL><Period> and <CNTRL><T> (<CNTRLl><Period> for wild-carding , <CNTRL><T> to list all, <SHIFT><TAB> to auto fill).
Any child nodes of an object will be displayed when „.‟ is used after the insight window has been opened.


Explain Plan
This option is very helpful to identify the access path of a SQL Statement.
You can get the Explain Plan from the SQL Editor, the Database | Monitor | SGA Trace Menu option (for Items in memory) or from the Session Browser.
Once the plan is generated you will get a menu like this:






Data Subset Wizard (Tools Menu)
This window lets you copy a portion of data from one schema to another while maintaining referential integrity, so that you can work with a smaller set of data.
The wizard creates a script that will copy a specified percentage of data beginning with all parent tables or from all tables with no constraints. You can specify a minimum number of rows. The wizard then continues with tables that have foreign key constraints, the rows copied are those whose parent rows have been copied into the parent tables.
The wizard consists of four screens which allow you to set options as follows:
Screen 1: Select source and target connections/schemas and specify where to save the script.
Screen 2: Select Objects to create in the script.
Screen 3: Set up the commands in and around the insert statements.
Screen 4: Set up any extents or tablespaces when the wizard is set to create objects.


Using Auto Replace
Toad allows easily add your own commands or give simple keystroke access to your commonly-used coding techniques.
Auto Replace is used to correct typo’s and to save you time.
To set up this option go to Edit -> Editor Options, Click on Auto Replace and you will see the existing Auto Replace options.
I entered the following options:
Sf       select * from
Pl       DBMS_OUTPUT.PUTLINE

So if I type pl followed by the space bar, it will be changed by DBMS_OUTPUT.PUTLINE


Project Manager Tutorial
Most IT professionals do not live exclusively in the Oracle database. Instead, they are using the power of the Oracle database to provide information to their custom web pages, applications, batch jobs, and much more. So someone using Toad to access the database is most likely also using spreadsheet, web development, word processing, and other applications. Toad's Project Manager provides a centralized area for the user to manage ALL of the items for a given application, task, or a project. This could be a collection of tables, stored procedures, database jobs, ftp folders, web pages, documents, etc.

For example, I have a project labeled TOADSOFT. I can use the PM to manage everything I need


Here you can see my project for managing QUEST content.
The QUEST project contains a node for the remote server where the site is hosted, a link to my Desktop and some files I need to frequently edit and find easily, Oracle tables I need to update for posting the Release Notes, URL's I need to keep an eye on, and a link to the folder where I keep a backup of all the web content.
I also have another project I use to manage the Beta release. I can zip up the files for the beta and DRAG-N-DROP the file to the Web Server to easily FTP the file.

How do I Add Something to a Project?
If you have already found your database object using Toad, you can easily add it to your project. You can mouse-right-click on the object in the Schema Browser and choose 'Add to Project Manager.' You can also add objects from Toad's Object Search dialog. It's important to remember that you can select MULTIPLE database objects and add them to a project simultaneously. If you have more than one project open, Toad will prompt you to choose the project you want to add the object(s) to.
To see just how powerful the Project Manager really is, bring up the options dialog by pushing the options button on the PM window. In the PM, we can configure what happens on Double-Clicks, R-Clicks|PopUps, and Drag-N-Drops.
Project Manager works in exactly the same way as the Schema Browser. In particular, the right-click context menu is identical, and you get the same display on the right if you select an item.
You can also create a REAL Directory, and if you drag and drop a table name over there you’ll find an actual file with the DDL to create that table and all of its supporting structures


Action Palette or Application Designer (like a macro)
Open the AppDesigner window from the Utilities | AppDesigner.
A database developer or database business analyst might need to do something in Toad related to the data content, and then repeat or schedule that task, instead of doing over and over again, you can use the APPDesigner. The AppDesigner feature allows Toad users to create “mini-applications” within the App Designer, and schedule these tasks.
The Appdesigner is broken into three main areas:
As an example:
I open Toad Editor, enter my query, and press Execute to make sure it works as intended. Then I right-click anywhere on the data grid and choose Save As from the context menu. On the Save as screen, I choose my options and parameters and click OK to verify that it works correctly. Then I reopen the Save As dialog; this time I click the camera icon at the bottom (or the lightning bolt on pre Toad 9.7 located by the minimize buttons). That opens a dialog for creating (but not running) a user-defined “Action” to perform this task.
I can now choose to run or schedule that application. If I choose to run it, Toad is simply executing the application within my currently running instance of Toad. That is, behind the scenes, it will execute the query and perform a Save As, but I won’t see anything flash by; I’ll just see a run status indicator such as the green Completed bar.
I can schedule that task to be performed periodically.
So where can you do this? Basically on any screen that has the yellow lightening bolt icon or the camera icon at the bottom, and the number of those screens is growing as we speak

Another example:
Most of the users love to use the “Save As” function in the right click menu for the data grid. But sometimes the user has to run the same query numerous times and repeat the steps to save the data off to the file format of their choice, that is a good example of using the Action Palette. 
Run the query in the Editor. And then right click on the data results and select “Save As”.
Continue to select your file format, and any options you want. Also remember to set a destination location for the new file.
Once completed, on the top right hand corner of this window, click the little yellow lightening bolt icon.
This will prompt you to give this action a name. Please provide a meaningful name and hit OK.
Under the View Menu, select the Action Palette option. This will bring up the Toad Action window.
Located in this window will be the new Action you just created. On the top of this window will be a “Schedule” icon underneath the green triangle icon.
Click on this and you can schedule the data extraction.
Just keep in mind that this is using Windows Task Scheduling to setup the job and you must have Windows up and logged in. You do not need to have Toad running in order for this to work. Now sit back and enjoy, while Toad automatically exports data for you to your desired location and in your desired file format.

Good information over here:
http://toadsoft.com/oravids/IntroductionToActions.htm
http://toadsoft.com/oravids/ActionsFromToadFeatures.htm
http://toadsoft.com/oravids/SharingAndSchedulingActions.htm



Action Console
What is the action console? Simply put, anywhere you see or work with an Oracle object in Toad, simply do a mouse-right click on it and the Action Console will give you Toad's FULL arsenal of action items for that object. ALL the power of Toad in a simple RightClick: Add Column, Constraint, Indexes, Analyze Object, Truncate and many more!!!



Object and Schema Compare
Perhaps one of the most popular Toad features for developers and DBAs is Schema Compare and Sync. 
With the DB Admin Module, you can also use schema definition files and perform synchronizations.
Schema Compare & Sync have been made actionable, and are available from the AppDesigner, or from the Window Snapshot button.
There are two ways to perform a Schema Compare using Toad:
   1. Using information stored in the Oracle Data Dictionary
   2. Using native Toad Schema Definition files.
The first method uses “brute force” to obtain the DDL information pertaining to every object in each compared schema.
The second method uses what are called Schema Definition (or schema snapshot) files. These files are encrypted, compressed files which contain all the information about every object in a schema at a particular point-in-time. The real beauty of using these files is that, not only are they an accurate record of what a schema looks like at a particular point-in-time, but when used to perform a schema compare using Toad, they take a fraction of the amount of time to process. What would take minutes to process using a data dictionary compare only takes seconds using this method.

In addition, Schema Compare has been expanded for easier use. You can now add multiple target schemas to compare, while still being able to switch between two schemas. In addition, you can use either a live connection to a database which loads all DDL information as you go, or schema definition files. These files are encrypted, compressed files containing all the information about every object in a schema at a particular point in time. You may want to use a schema definition file to run a time-sensitive comparison, but something additional is that when they are used for a schema compare, they take much less time to process.


Statspack and AWR Browser
The Toad StatsPack Browser (DBA module required) takes beginning and ending snapshots of database performance statistics and then offers graphical trending and time-series analyses based on those stats. The result is a gallery of useful charts for interpreting database performance.
+




It also contains advisories.
When two snapshots are selected (not checked, but selected), the Advice tab will give some info about the top wait event during the selected interval. Another way to display the advice is to double-click blue underlined waits in the top waits grid.




Data Import and Export
One of the most common development and test database tasks is to refresh data for users to run their code against. For this, many developers use the Oracle import and export utilities. But you really cannot see into a dump file, other than to ask for a table of contents.
Toad solves this problem with the Export File Browser, which is available by selecting Database | Export | Export File Browser.
Once you oopen your dmp file, I can view the contents of the dump file via the navigator tree view on the left side. I can also see the DDL for that object and its data under the tabs on the right side as well, so I can cut and paste the DDL to make sure the objects exist before the import.
Another handy tip: I can also see the data in a standard Toad data grid. This means I get all my right-click menu options such as Save As, Print, and Row Count.
Note that the Export File Browser must access the dump file to perform its job, so the file must reside on your PC (remember, Toad has a built-in FTP tool).


Trace File Browser
Oracle trace files have historically been difficult to examine, you needed to be an "expert" on TKPROF.
The Trace File Browser provides a way to display this information in a manner that is easy to read and easy to navigate so that problem areas can be quickly isolated.
The new Trace File Browser (under Database | Diagnose | Trace File Browser) provides far more information than was previously possible. In addition, after you have browsed a Trace File, a Benchmark Factory project file can be pushed to Benchmark Factory for workload replay.


Code Expert
What if you’re a DBA trying to track down a performance problem somewhere in the millions of lines of PL/SQL code in your database? Toad has a batch mode interface in Code Xpert designed for that very purpose. It scans the code and highlights line that needs attention—finding the proverbial needle in the haystack for you.
Just Select Database | Diagnose | Code Expert , Load your objects, select the ones that you want to Review and you are ready to go



Click on a query to see the binds variables and the values passed for execution.


Toad will show the number of queries that run under specific amounts of time. Drill down to an individual statement to see the Execution vs Parse vs Fetch vs Wait times so you know EXACTLY how to approach a tuning scenario.



Database Browser
There have been some major enhancements to the Database Browser. You can now use it as a central point for your database administration. As before, you can navigate to every database simultaneously, and drill down into any of them to administer database and schema objects.
Now you can right-click on a database node and perform a number of additional administration operations. You can go directly to the:
    * Top Session Browser for the selected database.
    * Session Browser for the selected database.
    * DB Health Check on the selected database.
    * AWR Browser
    * Generate RMAN Scripts
    * And many more...



RMAN Script Templates
Oracle RMAN scripts can be challenging and time consuming, especially for less experienced DBAs and they wanted an easier way to create and maintain scripts. Toad 9.7 supplies basic scripts that can be copied, edited and stored for re-use. Also, Toad variables can be embedded into the RMAN script.
You can edit existing RMAN scripts and add and delete scripts to and from the scripts list from the Options | RMAN Templates page.
You can then generate RMAN scripts from the Database Browser.
   1. From the Database Browser, select the database where you want to execute the script.
   2. Right-click and select Generate RMAN Script and select the script you want to generate
   3. Enter any required variables and click OK. The script will open in the Editor window, where you can then save or execute it via F9. Executing will open and run RMAN outside of Toad, and then close independently.


Since Toad 9.7 the Database Browser has an addition menu named “Generate RMAN Script”. From this menu you can call several predefined scripts and you can add your own scripts as necessary.
The “Basic Script to setup RMAN for backups“ allows you to set the configuration parameters.
Calling this script opens an additional parameter window to set or change some basic variables like log file location, backup location, etc.


Data Generation
New to Toad 9.7 professional is a feature that provides a way to generate test data for your schemas and tables. Video with Demostration
Toad will even honor your foreign key relationships when creating key values. Toad can generate real-looking product data or you can use a SQL statement to generate data values to be used for your new rows.
Data generation is implemented in the following locations:
    * Schema Browser Left Hand Side (Object Panel) - right-click and select Generate Data.
    * ER Diagram - Click the Data Generation button:
    * Create Table window- Click the Generate Data tab.
In particular, you can specify:
    * The number of records to create
    * How to handle constraints
    * How to handle Referential Integrity
    * How to commit your work


Rebuild Multiple Objects
In TOAD you have an option to move several objects to other tablespaces. It's as simple as:


An then Select the objects that you want to move



SGA Trace Optimization
You can use the SGA Trace / Optimization command to view information about SQL statements that have been executed and the resources they used. Whereas Auto Trace and TKPROF information is specific to a single statement, SGA Trace Optimization displays statistics from multiple SQL statements currently present in Oracle's SGA (System Global Area).
Go to Database -> Monitor -> SGA Trace Optimization to open the SGA Trace window. You can set several options from this screen in order to search for SQL statements. The default settings are for ALL Statements for ALL Users, but you can click on the corresponding drop-down box and choose another option to change these choices. You can limit the selection to a single statement type (e.g., SELECT statements, UPDATE statements, anonymous PL/SQL, etc.) or to a specific user. You can also enter a text string in the SQL Search Text box to limit the rows returned to statements containing that text string.
Click on the "Refresh the List of Statements" button to retrieve the most resource-intensive SQL from the SGA. This returns all of the queries that match your criteria. The screen is divided into two parts:
    * The query results grid on the top half of the screen shows the query that was executed and the associated resources used (memory, disk reads, loads, etc.).
    * The bottom half of the screen displays the full SQL statement, execution statistics from the Oracle shared pool, and the Explain Plan for the query.
When necessary, you can pass a SQL statement into the SQL Editor from the SGA Trace window. Highlight the desired statement, then click on the "Load selected statement in a SQL Editor" button on the SGA Trace toolbar.
This toolbar also contains a button to "Flush the SGA." Your Oracle privileges dictate your logged-in user's ability to use this function.
    NOTE: SGA Trace Optimization requires access to a number of Oracle V$ objects.

So how do you utilize this information?
If you primary interest is simply finding highly shared SQL statements (i.e. those that get executed by many sessions), the main data grid has columns for “Users Opening” and “Users Executing”. You also can look at the “Sessions” tab contents for the statement to see the details of all those sessions accessing that shared SQL statement. However if your key interest is to tune those statements (once found), then the “SQL” tab offers toolbar icons to send the chosen SQL statement either to the Toad Editor or SQL Optimizer for manual or automatic tuning, respectively.
Remember, tuning those statements which get called the most either by a single session or collectively by many sessions will yield the greatest return on investment. If you can make a statement 2% faster and it gets called thousands of times per day (even if by different users), than the net effect will be highly positive.


Tuning SQL (Optimize SQL)
Wherever you encounter SQL in Toad, you can also invoke a tuning session for that statement by simply pressing the “Optimize SQL” button.

Tuning Current Statement from the Editor
When handling a problematic SQL statement in the Editor in Toad, it is very easy to move the statement into our tuning lab. Just select the SQL you want to tune, and hit the "Optimize SQL" button. Again, it is the Yellow Beaker with the Tuning fork (Found on the right of the printer button.). You will then be prompted to send the SQL code to the Tuning Lab or the Batch Optimizer. I recommend you become comfortable with the Optimize SQL which allows you to manually tune a query before you use the automatic Batch Optimize technology.

Optimize SQL
The Tuning Lab, or the "classic Tuning window", guides the user through analyzing the current execution plan and then to generating SQL query rewrites that will hopefully find a different execution plan that positively affects the execution time. Toad can generate and evaluate the theoretical execution plan.


The SQL Information tab under the plan will let you know if there are any problems with your plan that could affect performance.
You can view the plan in several different formats and even get detailed documentation for each plan step – all by mouse-right-clicking!


Ready to tune?
With your statement in the "Optimize SQL" window and "SQL Details" panel, you have several options:


As each scenario is executed, they are ranked by Elapsed Time. You can cancel execution at any time, or let it continue through all of the rewrites for a more exhaustive set of scenarios.
You can easily compare any two scenarios by seeing both the SQL syntax and execution plan differences side-by-side.

Advise Indexes
The indexing feature will analyze a collection of SQL statements to see which tables and views are being queries, and then will look at the existing set of indexes. It will then generate a list of alternative indexes you can evaluate for optimal execution of your original SQL statements. We recommend the SQL Query re-write tuning methodology whenever possible as adding indexes to your system can affect the performance of other SQL queries found in your code and views. If you need to create a new index, then be sure to use our Impact Analysis technology.



Analyze Impact
Whenever you add one or more indexes to the database, the execution plans for your applications‟ embedded SQL can be dramatically impacted. The Impact Analyzer allows you to model these proposed system changes so you can see exactly how your new index affects everything else in the database. We generate the new theoretical index and the new execution plans for each of your production SQL statements. You can see what the before and after ramifications are to your system whenever you propose a change.
Identify key SQL code, propose a change to the system (a new index?), then see how that change affects the execution plans for your SQL code.



Batch Optimizer
The tuning technology now allows a user to send multiple tuning jobs (any collection of SQL or any embedded SQL found in a set of PL/SQL programs) to a tuning queue. Each section of code will be evaluated. Any "problematic" SQL code will be automatically tuned. You will be informed what SQL the tuner was able to generate that will allow your query to run faster, and by how much!



Tuning Lab
The Tuning Lab, or the "classic Tuning window", guides the user through analyzing the current execution plan and then to generating SQL query rewrites that will hopefully find a different execution plan that positively affects the execution time. Toad offers an easy-to-understand execution plan which is automatically generated when a statement is moved into the Tuning area.


Toad takes selected tuning techniques like syntax transformation, hints, where clause order permutations, etc to generate new queries that force Oracle to consider new execution plans for your queries.






Run Toad off a USB Flash Drive
Here are the steps:
1. Format the USB Flash Drive as an NTFS file system.
a. File explorer, right hand mouse, properties, hardware tab
b. Select the USB Flash Drive and press the properties button
c. Policies tab, choose Optimize for Performance and press OK
d. Format the USB Flash Drive – NTFS should now be available

2. Create TOAD_FLASH directory on your USB Flash Disk (at topmost level)

3. Download and then unzip the TOAD_FLASH.zip file onto your USB Flash Disk

4. Unzip the contained Oracle Instant Client installation file onto your USB Flash Disk

5. Install Toad for Oracle and copy the Toad home (install directory) to your flash drive
Example: xcopy /s /q "C:\Program Files\Quest Software\Toad 9.7" "X:\Toad 9.7\"

6. Run TOAD_FLASH_SETUP.bat file to install (and save pre-existing Toad setups)

7. Run TOAD_FLASH_RUN.bat file to launch Toad (must enter license first time)

8. Run TOAD_FLASH_RESTORE.bat file to restore PC back to prior Toad state

You can download the file at http://www.bertscalzo.com/Files/TOAD_FLASH.zip




Other Good Tools



Resources collected from
Get to know Toad 8.0
Get to know Toad 8.5
Get to know Toad 8.6
Get to know Toad 9
Get to know Toad 9.1
Get to know Toad 9.5
Get to know Toad 9.6
Get to know Toad 9.7



Download Location

 

Toad for Oracle 9.7.2.5 Parte1

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874744&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part1+.rar

Toad for Oracle 9.7.2.5 Parte2

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874745&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part2+.rar

Toad for Oracle 9.7.2.5 Parte3 

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874746&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part3+.rar

Toad for Oracle 9.7.2.5 Parte4

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=7874747&desc=Toad+for+Oracle+9.7.2.5+www.softarchive.net.part4+.rar


Toad 9.7.0.51.part1 .rar

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=8918324&desc=TOAD+9.7.0.51.part1+.rar

Toad 9.7.0.51.part2 .rar

http://rapidlibrary.com/download_file_i.php?qq=quest%20toad%209%207&file=8918325&desc=TOAD+9.7.0.51.part2+.rar