Manual Toad 10

Get to Know Toad 10 Last Revised: Monday, September 21, 2009

Contents Introduction In All Toad Editions: 

Unicode



Actions



Alter

                 

Support

Type Application Data Fo lders Editor ER  Diagram Grids LicensingStructure Load DatabaseObject Network ConnectionI ConnectionInfo nfo ProfilerAnalysis Project Manager R ebui ebuildTable Script Manager SearchFunctiona lity Server SideObjectWizard SettingParameters Set Sequence TNS Names Editor User Data Migrationon Upgrade Variables In Professional, Development Suite and DBA Suite Editions:

 

CodeXpert Data Generation In the DB Admin Module and DBA Suite Editions:

   

Database Browser DatabaseHea lthCheck Database Monitor Instance Manager Options Introduction The release of Toad® for Orac le 10 brings an array of new features, not least of which is Unicode support. For fu ll details and other ways to learn Toad, see the R elease Notes and the built-in He lp (press F1). This page provides a quick wa lk-through of some of the features introduced in Toad® for Orac le 10. Links to video walk-throughs are provided where avai lable. In addition, new videos are often

being added to the Video Page at Toad Wor ld where you can also find videos from previous versions. Furthermore, you can find detai ls of the various Toad Editions and additional products included in them at Quest Software's Toad for Orac le product page. N ote:

This overview was created using Toad BETA release version 10.0.0.30. As such, some descriptions may vary slightly from the final release. R eturn

to Contents

In All Toad Editions: Unicode Support 

Toad now supports Unicode. For people already using Unicode-enab led databases, this shou ld be a seamless transition. N ote:

Some Oracle features are not Unicode-enabled, or have specific Unicode requirements to function. Please see your Oracle documentation for information about these features. Thereisanonline video tutorialforthisfeature. 





Toad Advisor now checks that NLS_LANG value matches client character. Default Encoding option added to Options | General to set default encoding for new and for saving fi les.

Editor

tabs

If you are an upgrading user, you wi ll need to make the fo llowing change to your LexLib for the Editor parser to work correctly with Unicode: y

From the View menu, se lect Options.

y

Click the Editor - Behavior node.

y

Set the language dropdown to PL/SQL and then c lick the Edit Language button.

y

Click the Parser tab and select Any Name.

y

Add

(?r) to the beginning of the " Any name" parser ru le:

y

Click OK or Apply to save changes.

R eturntoContents

Actions 





AppDesigner

has been renamed to Automation Designer.

When specifying connections on the command line (toad.exe -c ), these connections wi ll now be used in the Actions specified afterward ( -a ), instead of the connection current ly bound to the Action. In some actions, you can a lso specify connections to execute against in the Automation Designer.



ActionParameter

y

Actions

files:

can now accept parameter fi les. They are in I NI format. R ight click on an Action/App in Automation Designer and choose "Create Parameter fi le" to build an I NI file based on the current Action properties. It will create property=va lue pairs for the things which can be overridden. This parameter file can then be used in the Automation Designer ('R un with parameter fi le') or on the command line by using a p ipe to separate the Action/App name from the fi lename. For examp le: toad.exe -a "App->Export Dataset1 | c:\data files\exportDataset1.ini"

y

y y y y y y y y y y

You will know which Actions can generate/read an I NI file by whether or not the 'Create parameter file' popup menu item in Automation Designer is enab led. Here is a samp le section from an INI file which shows an Execute Script Action:

[47]

Name=Execute Script1 Type=Execute Script ItemCount=2 Item0=c:\try1.sql Item1=c:\try2.sql Output=1 {1=SingleFile, 2=SeparateFile, 3=Clipboard, 4=Discard} Output Location=C:\some folder\output.txt ConnectionCount=2 [email protected] [email protected] [47] is an interna l identifier. "Name" and "Type" are on ly for your use, to find your Action within a longer App INI file. Each Actions INI section will be unique to that Action, and in the case of  things like enumerated types, wi ll include explanatory notes embedded within the line itself. In this example of 'Execute Script,' two connections are specified. This wi ll override the bound

connection of the Action. If that line wasn't there, the bound connection wou ld be used. Theorder of precedenceforwhichconnectionsgetused: Those specified on command-line always override everything else If 1 is not present, those specified in an I NI file are considered next Finally, the connection bound to the Action is used if none are in 1 or 2

o o o

R eturntoContents

Alter Type 

Altering R eturn

a Type in the Schema Browser now loads the object in the

Editor.

to Contents

Application Data Folders 



The default installation directory for new insta lls enables roaming profile support by defau lt. In the View | Toad Options | General | Application Data Directory, the Use Default button now points to the user's main app lication data fo lder. The Use Local Default button points to the user's local application data fo lder, which does not support roaming profiles. You must restart Toad for a change in this option to become active. R eturntoContents

Editor 

New menu item added to the main Toad Editor menu. "Sp lit Size Horizonta lly" This item will auto size the Editor so that there is e qual space allocated for the edit contro l and the bottom docking panels. The defau lt shortcut is CTRL+F2. You will need to manua lly add the item to the too lbar or reset your too lbar to see this if upgrading. R eturn

to Contents

ER Diagram In addition to the fo llowing information, there is an online video tutorial for this feature. 



The ER  Diagram has been expanded in Toad 10. This functiona lity is based on, and works with, the Toad Data Mode ler. Toad's ER  Diagrammer is not meant to be a mode ling tool, but it can help you. You can now see the objects included referentially when you add objects using Integrity:

R eferential





In addition, you can now subdivide your diagram into mu ltiple workspaces.

Separate objects into categories, and co lor code them, and add Mode l information to the diagram.



Use



Create detailed reports in severa l formats, zip, and emai l them.



Export



With the appropriate Toad



Create a diagram and send it to Toad Data Mode ler for detailed modeling.

the Zoom and Snap to Grid features to organize your diagram.

R eturn

diagrams to severa l different graphics fi les. Edition,

you can a lso create random test data for se lected objects.

to Contents

Grids In addition to this information, there is a lso an online video for this feature. 

Grids are now consistent throughout Toad. Some new featuresinc lude:

y

Grids now share a single popup menu.

y

R eset

y

Grids can hand le block selection if row se lect is unchecked and mu lti-se lect is checked.

y

y

Grid View restores the grid to the origina l configuration so you can undo any groupings, bookmarks and so on with one se lection.

Grids can be grouped by a co lumn header by dragging the header into the Group By area at the top of the grid. This feature can be togg led on the right-c lick menu.

Grids that had specia l functiona lity now have an upper too lbar containing that functiona lity, as in the R ebuild Multiple Indexes grid.

y

y

y

y

You can check or uncheck a ll boxes in a grid co lumn by right-c licking in the co lumn header and selecting the appropriate option.

Navigator toolbars have been moved to the bottom of the grid area. If you do not see a navigator, right-c lick in the grid and se lect Toggle Navigator.

Single

R ecord

View is now part of the Navigator toolbar.

You can bookmark one location in the grid and return to it later. Put your cursor in the row you want to bookmark and c lick the bookmark button on Navigator toolbar.

y

To return to the bookmark, c lick the Goto Bookmark button on the same too lbar.

y

Show/Hide columns with the Quick Co lumn Customization drop down in the upper left.

y

All

customizations are remembered (co lumn order and size, group header visibi lity, and so on).

R eturntoContents

LicensingStructure 

The licensing structure has been changed to support one key for a ll products in a Toad you are upgrading your version of Toad, o ld license keys are still supported. R eturn

Edition.

If 

to Contents

Load Database Object 

Load Database Object now a llows incremental searching in both the schema box and the object grid. R eturn

to Contents

Network Connection Info 

Now stored in NetworkConnections.dat rather than Toad.ini. It is a lso encrypted using hte same method as the connection information, and tied to the logged in user. R eturntoContents

ProfilerAnalysis 

Show anonymous blocks toggle in right-click menu added. This defau lts to the setting made in the Profiler tab in the Editor.

R eturntoContents

Project Manager 

AutoConnect

mirrors auto-connect property of the login record for Toad as a 2-way mirror, rather than as an independent auto connection. R eturntoContents

RebuildTable 

Can rebuild tables containing LONG columns. R eturntoContents

Script Manager 

Has been redesigned for improved support for mu ltiple connections. R eturntoContents

SearchFunctionality quick search bar has been added to the main too lbar. From this too lbar you can:



A

y

SearchToadWor ld online

y

Search Toad World and other Toad-re lated sites

y

Search AskToad (the Toad wiki)

y

SearchKnow ledgeXpert

y

Perform keyword searches against the Toad he lp file.





You can enab le/disable the search bar by right-c licking on the toolbar and se lecting "Online Search". You may need to restore the too lbar defaults to have it disp lay initially. To do this, right-c lick on the main too lbar and se lect Restore defaults. R eturn

to Contents

Server Side Object Wizard



Now a part of Toad instead of a separate app lication (required for Unicode support).



Data Generation scripts added. R eturntoContents

SettingParameters 

Setting Parameters now provides lists for parameter se lection, and larger editing areas for large parameters. R eturntoContents

Set Sequence 

Set Sequence feature rep laced with an auto-increment via sequence and trigger. y

y

From the Schema Browser | Tab les page, right-c lick and select Add | Trigger/Sequence Pair and then enter the required information:

Doub le-check the SQ L created, make any required changes, and then c lick OK.

y

R eturn

Once the sequence/trigger pair is set, you can high light columns populated by it by doing the following: From View | Toad Options | Schema Browser - Visual, select Highlight columns populated by sequence/trigger pair. to Contents

TNS Names Editor An

online video tutorial is also available for this feature.



Delete host nodes in Host View mode



Delete multiple nodes (host or service)



R etain

relative position in the tree view when nodes deleted

R eturn

to Contents

User Data Migration on Upgrade 

new migration tab is added to the initial startup wizard to migrate your existing app lication data from a previous insta llation of Toad. Upon startup, Toad wi ll attempt to detect the application data paths of previous ly installed versions. If one is found, it wi ll select the most recent installed version and give you the option of migrating data fi les from that insta llation to the current insta llation. It will also provide the option of specifying a custom location, or the option to skip the migration and perform a c lean install. A

R eturntoContents

Variables 

Variables can now be added within definition filenames in several of the Compare and Generate windows. For examp le %DATEFILE% and %TIMEFILE% can be used to stamp the date and time of creation (These are inc luded in the default filename). Otheruser-defined variab les mayalso be added.

R eturntoContents

In the Professional, Xpert, Development Suite, and DB A Suite Editions: CodeXpert 

Command line XML output now has an additiona l tag called comment_count to list the number of  comments in the code being ana lyzed.

R eturntoContents

Data Generation 

data generation abi lity can now create more rea listic data. Generators were added to create various address, geographica l, personal, and business data formats. Also included is the ability to reference a foreign fie ld, a hard-coded va lue, and the abi lity to enter a custom SQ L statement. Straight random and Unicode data are present. Enhanced

An 

y

online video tutorial is also available for this feature.

Three generator engines are supported: Internal: This will create a script with "n" I NSER T statements per tab le (depending on the individual table's settings). An option is also available to commit every "x" rows. C aution:

This will create a very large SQL script, which will take longer to execute, but does not  require any packages installed on the database server. y

y

DBMS_R ANDOM: This will use the DBMS_R ANDOM package to generate data, and is simi lar to the behavior in Toad 9. 7. DBMS_R ANDOM will need to be insta lled on the database server for this option to be avai lable. TOAD_DATAGEN: This will use a TOAD-specific package to generate data on the server. The advantage is that this wi ll generate a much sma ller SQL script, and will perform faster. N ote:

You will need to install the TOAD_DATAGE N  package through Server Side Object Wizard in order to use this feature. This package can be installed locally, or in the global TOAD schema. 

Using

Toad 10 you can create more meaningfu l random data for your tab les. Oneway of  doingthis:

y

In the Schema Browser, select the tab les for which you want to generate data.

y

R ight-click

and select Generate Data.

y

y

Set General options, including Data Generation

Engine.

Click on a tab le or column node and set options specific for that node. All options must be set individually, although the actua l generation can be done a ll at one time.

y

Click Show SQL to check the code before running it, or c lick OK to generate data immediate ly. R eturn

to Contents

In the DB

Admin

Module and DBA Suite:

Database Browser 

R ight-click R eturn

to execute a Quick Script.

to Contents

Database Health Check 

Many new hea lth check items have been added. The Database category has been integrated into new categories: (Config, Alert Log, Storage, and Performance).



Settings has been moved to its own tab.



New health check items inc lude:

y

List default initializationparameters

y

List non-defau lt deprecated initia lization parameters. (10g+)

y

Verify compatible matches version major.minor

y

Verify optimizer_features_enab le matches version major.minor

y

Verify optmizer_index_caching>= 50 (9i+)

y

List incompatible parameters if pga_aggregate_target (10g) or memory_target (11g) is set

y

Verify pga_aggregate_target>+10MB (10g on ly)

y

Verify control file count>=2

y

Verify CPU count - - ( let Orac le determine the value)

y

Verify cursor_sharing='SIMILAR ' (9i+)

y

Verify cursor_space_for_time='TR UE' (pre 11g)

y

Verify db_cache_size set instead of db_b lock_buffers (9i+)

y

Verify buffer cache >=200MB

y

VerifyLarge Pool >=50MB

y

Verify objects using KEEP buffer pool exist if db_keep_cache_size is set

y

Verify db_keep_cache_size>=50MB if objects exist which use

y

List db_nk_cache_sizes without corresponding tab lespaces (9i+)

y

List tablespaces without corresponding db_nk_cache_sizes (9i+)

y

Verify db_block_size<=4K for

y

Verify multiblock_read_count between 4 and 16

y

Verify disk_asynch_io is TR UE (pre-11g)

y

Verify compatibility of db_writer_processes and dbwr_s laves with disk_asynch_io setting

y

Verify dm _ l locks=0 or >=transactions * 4

y

Verifyfilesystemio_options='SETALL'

y

Verify fast_start_mttr_target is set when log_checkpoint_timeout=0 (9i+)

R AC,

RECYCLE

buffer pool

>=4K for non- R AC

y

Verify max_dump_file+size<=20MB

y

Verifyopen_cursors>=50

y

Verify query_rewrite_enabled = TR UE (9i+)

y

Verifyrecyc lebin='OFF' (10g+)

y

Verify remote_login_password_fi le='SHARED'

y

Verifysession_cached_cursors>=20

y

Verify sga_target>=200MB and sga_max_size same va lue (10g+)

y

Verifystar_transformation_enab led=TR UE

y

Verify sq _trace = FALSE (pre-11g) l

y

Verifytimed_os_statistics = FALSE

y

Verifytimed_statistics = FALSE

y

Verify trace_enabled = FALSE (9i+)

y

Verify SYS.AUD$ isn't in SYSTEM tab lespace

y

Verify AWR  collection interval >=30 minutes, retention <=90 days (10g and newer)

y

List connect time, version info, and a few basic ratios

y

Listdatafile IO distribution

y

List objects where number of hash partitions is not a power of two

y

List segments with <1% of extents remaining and >10 maxextents

y

Listsegmentswith>1000 extents R eturntoContents

Database Monitor 

Alert



You can now run any action (inc luding scripts) when a specified thresho ld is hit.







options have been moved from the main Options window to the Database Monitor screen.

You can configure the monitor to begin co llecting data whenever a connection is made. Then, when the window is opened, all data is displayed.

The DB Monitor tray icon now f lashes red if there is an issue that can better be addressed from Spotlight for Orac le. R ight-c lick on the tray icon to launch Spotlight, or choose to open the DB Monitor. Wait events chart has been expanded and updated for Orac le 10g and 11g. R eturn

to Contents

Instance Manager Options 

Options | Instance Manager - has now been integrated into the Instance Manager window. For example, the grid now inc ludes checkbox columns in each server row to se lect servers to monitor or alert when down.

R eturntoContents