Setting Some Advanced Schema Browser Options


TOAD's Schema Browser is a highly complex bit of code with numerous capabilities and nearly endless options. Although some of these options have already been examined within this chapter, there are still many more. In fact, there are so many options (and growing) that the TOAD Options category for the Schema Browser now has two complete pages. Unfortunately the options on each page do not seem to be based on any logical grouping, but rather just an overflow of what could fit on one page. So you'll need to visit both pages to be certain you've chosen all of the right option settings.

The first page, Page 1 as shown in Figure 2.31, offers over a dozen options for controlling general Schema Browser behavior.

Figure 2.31. TOAD Options ”Schema Browser Page 1.

  • Enable DROP-ALL Buttons ” Adds button to each tab for dropping all objects under that tab and is good for the current session only. This option is not as useful now that the Schema Browser supports multi-select.

  • Limit Data Grids to N Number of Rows ” Causes TOAD to populate the table, view, and snapshot data tab grids N rows at a time. TOAD prompts between iterations on whether to continue or not. Useful when examining very large tables and not using data filters.

  • Only Show One Schema Browser per Database Connection ” Because Schema Browser is a Windows resource “ intensive interface by nature, limits TOAD to one Schema Browser per connection in order to save on PC resources.

  • Cache Cursors Used for Queries ” Speeds up the browser performance at the expense of saving 12 cursors. The DBA should have adequate INIT.ORA parameter settings based on the number of concurrent TOAD users so that this does not become an issue.

  • Set Focus to Table Grid Data After Selecting Table ” Some users like to examine sample data as the first step in looking at their tables. This speeds up the process by sending them there first. Recommend using either data filters or the option for Limit Data Grids to N Number of Rows when this feature is turned on. Otherwise, you may find yourself waiting when million-row tables are selected!

The second page, Page 2 as shown in Figure 2.32, also offers over a dozen options for controlling general Schema Browser behavior.

Figure 2.32. TOAD Options ”Schema Browser Page 2.

  • Auto Refresh Details After Selecting Object on Left Hand Side ” Causes TOAD to automatically refresh the RHS when a selection is made on the LHS. Recommend that you turn this on.

  • Use Selected Optimizer Hint for Dependency Queries ” Forces TOAD to use the hint "Optimizer mode for DDL queries" that was specified in Options, Oracle. Recommend that you set this to "/*+ RULE */" for best results (in general).

  • Save Data Grid Layouts ” Causes TOAD to save the grid layouts regarding column order, fixed columns , and exclusions.

  • Save Browser Filters ” Causes TOAD to save both the browser object and data filters to a file named SCHEMA.FLT in the TOAD TEMPS directory.

  • Allow Multi-Select on Left-Hand Lists ” Allows you to use multi-select with context menu options. This option is new for TOAD version 7.4. Recommend that you turn it on.



TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net