Toad

RAC Support

2008-09-07T23:38:00.000-07:00

If you have multiple database server boxes, Oracle RAC lets you start an Oracle instance on each server, and have all those instances open the same shared database (or shared set of data files). In this way, you can scale the size of your database server by adding more computers as you add users. Multiple computers, one database. Toad supports Oracle 10g's support for RAC systems.

Additional Information for RAC Connections
When you log into a RAC connection, Toad notes this fact and makes additional information available in some of its windows to help you manage that connection.

Caption
If a RAC connection is in effect, the caption of the Toad Main window will reflect this by showing: TOAD: RAC[n], where n is the session id.

Connection bar
In the connection bar, RAC connections are listed as SCHEMA@RAC[n], where n is the instance number of the connection.

Database Monitor
Within the database monitor, all information is provided as per a single connection. However, it is summarized or aggregated for all the instances that compose the RAC cluster. For example, looking at SGA memory - if each RAC instance is 150 MB, and you have two RAC instances, this column will display 300MB.

Oracle Parameters Screen
RAC database single grid view - The Single Grid checkbox above the grid and to the right of the toolbar toggles whether Toad displays a single grid or a multi-grid. Toad sorts first by default on the option and then by the instance name for easier readability.

RAC database multi-grid view - If you choose the multi-grid view, Toad displays a separate tab for each RAC instance.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.

Oracle 10g Support

2008-09-06T23:36:00.000-07:00

Toad 8 was considered tolerant of Oracle 10g meaning that it could connect and operate essentially as it does for the previous versions of Oracle. Prior versions do not connect to the 10g database.

Toad for Oracle Version 8.5 supports the 10g database further by exploiting many of the new features/functions introduced in 10g.

Rename Tablespace
Tablespaces can be renamed by Right-clicking in the schema browser.

Default Tablespace
The schema browser indicates default temporary and default permanent tablespaces, and they can be changed by right-clicking.

Tablespace Groups
Tablespace groups are supported in the create/alter tablespace windows, and in the create/alter user windows.

Segment Advisor/History
There is a complete screen in TOAD to interface with Oracle’s Segment Advisor.

Globally Hash Partitioned Indexes
These are supported in the Create and Alter index windows, and in ddl extraction.

Datapump Wizard
Toad supports the Oracle datapump in the Quest DBA module, with new data pump import and export wizards, and a data pump job manager.

Online Segment Shrink
Supported in the following screens:

Alter table

Alter snapshot

Alter snapshot log

Alter index

Undo Advisor
There is a complete screen in TOAD to interface with Oracle’s Undo Advisor.

Improved Job Scheduler – Monitoring
New Schema Browser Tabs
New Schema Browser tabs interface with the Oracle 10g Scheduler.

Scheduler Jobs

Job Classes

Schedules

Programs

Windows and Window Groups

Create/Alter windows
There are create and alter windows for all of the new Schema Browser tabs.

Support in Generate Schema Script and Compare Schemas
All of the new Oracle scheduler tabs are supported within Generate Schema script and compare schemas.

Recycle Bin
New schema browser tab with full support for recycle bin operations including flashback table and purging of recycle bin.

New Data Types
DOUBLE, FLOAT, BINARY_DOUBLE, BINARY_FLOAT Supported in data grids and create/alter screens.

Big File Tablespaces
Supported in create/alter tablespace screen.

Global Partitioned Indexes - Hash Partitioning
Supported in create/alter index screen and in script generation.

Instant Client
TOAD can connect using this client.

New Row Timestamp pseudo-column
Supported in data grids.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.

Citrix Support

2008-09-05T23:35:00.000-07:00

Toad supports installation on Citrix servers.

Installing Toad on a Citrix server
Toad must be installed on the Citrix server by the Citrix administrator. Users then connect to this instance through their Citrix logon.

Citrix support is enabled with the appropriate installation option - Citrix/Terminal Server on the Select Installation Type dialog. Toad requires write access to the server registry during installation and read access during run-time to achieve Citrix support.

Full procedures for installing Toad on a Citrix server are located in the Getting Started Guide.

Connecting to Toad through Citrix
To connect through a client

Log into the Citrix Program Neighborhood and execute Toad.

Note: The first time you execute Toad you will be asked to enter a license key. Your Citrix administrator will provide you with the license key.

User Configuration Files in Citrix
Toad is installed on the Citrix server, and individual user settings are maintained on each client machine.

Individual user settings and properties files are maintained in the user's settings file:

C:\Documents and Settings\user_name\Application Data\Quest Software\Toad

Script Manager and Citrix
Toad installs packaged SQL Scripts with the Script Manager. When Toad is run in a Citrix environment, the default paths to these script manager files will be wrong.

To use these, you will need to manually change these paths once.

To change the Script Manager paths for use with Citrix

Open FileScript Manager and select the DBA category from the dropdown box.

Click the move button and enter your new path: C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\DBA.

Repeat for the Schema Objects category and move to C:\Documents and Settings\User Name\Application Data\Quest Software\TOAD\ScriptMgr\Schema Objects.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.

Registering Toad

2008-09-04T23:33:00.000-07:00

The Product Authorization dialog box allows you to input the Quest software registration ID. This indicates to Toad that you are an authorized user.

To register Toad

Select HelpRegister Toad menu item.

Click in the Enter authorization key field and type your key. Toad will automatically add the hyphens in the appropriate location.

Click OK to complete the process.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.

Introduction to Toad

2008-09-03T23:32:00.000-07:00

Toad is a powerful application development tool built around an advanced SQL and PL/SQL editor. Using Toad, you can build and test PL/SQL packages, procedures, triggers, and functions. You can create and edit database tables, views, indexes, constraints, and users. The Schema Browser and Project Manager provides quick access to database objects.

Toad’s SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data.

With Toad you can:

View the Oracle Dictionary

Create, browse, or alter objects

Graphically build, execute, and tune queries

Edit PL/SQL and profile stored procedures

Manage your common DB tasks from one central window

Find and fix database problems with constraints, triggers, extents, indexes,and grants

Create code from shortcuts and templates

Create custom code templates

Control code access and development (with or without a third party version control product) using Toad's cooperative source control feature.

PL/SQL Debugger
The optional PL/SQL Debugger lets you step through the code as it executes. With this module you can run a debug session with or without arguments, set breakpoints, watch variables, and more.

Quest DBA Module
The optional Quest DBA Module adds database administration functionality to Toad. With this module you can manage space, compare schemas, monitor database performance, create new databases, maintain redo logs, perform health checks, and more.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.

Toad Editions

2008-09-01T23:30:00.000-07:00

Toad for Oracle, Version 8.5 comes in four editions. So you can choose the edition that is right for your environment.

Toad Editions
Edition
Description

Toad for Oracle
Toad for Oracle Provides the foundation and basic tools for Oracle professionals to create and execute queries and build and manage database objects. This includes XML editing, data browsing, data compare, SQL recall, code snippets, and code formatting. This edition also lets you plug into Toad's added utilities.

Toad for Oracle Professional
Includes all of Toad for Oracle, PLUS

This edition includes PL/SQL Debugger, Script Debugger for SQL*Plus scripts, CodeXpert, and integrated PL/SQL Knowledge Xpert. It also includes Data Pump for Oracle 10g.

Toad for Oracle Xpert
Includes all of Toad for Oracle Professional, PLUS:

This edition includes the SQL Tuning Module and SQL Scanning.

Toad for Oracle Suite
An entire application lifecycle package in one.

Includes all features of Toad for Oracle Xpert plus a variety of development tools.

This edition includes Quest DBA Module, Database Administration Knowledge Xpert, DataFactory® Developer Edition, Benchmark Factory® for Oracle, and QDesigner™ PhysicalArchitect for creating and reverse engineering accurate physical data models.

Optional add-on modules
Quest DBA Module
Adds advanced database administrative functionality to Toad.

With this module you can manage space, compare schemas, monitor database performance, create new databases, maintain redo logs, and more.

Knowledge Xpert for Oracle Administration (requires separate download and installation from Toad for Oracle).

SQL Tuning Module
Identifies performance issues and provides Oracle database tuning so you can resolve bottlenecks.

From Toad® for Oracle 8.5 © Copyright Quest® Software, Inc. 2005. All rights reserved.