Best Practices
Best Practices
You can use Best Practices to analyze your SQL statement and database to recommend common techniques for improving database performance. Since the recommendations can also affect performance of other ...
Generate Indexes in Optimize SQL
Generate Indexes in Optimize SQL
SQL Optimizer identifies columns to use as index alternatives for a SQL statement after it analyzes SQL syntax, relationships between tables, and selectivity of data. SQL Optimizer then combines ident...
Deploy Outlines
Deploy Outlines
The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equ...
Batch Optimize SQL
Batch Optimize SQL
To batch optimize SQL Select the Batch Optimize tab in the main window. Click Add Code to Optimize in the Batch Job List pane and select All Types. The Add Batch Optimize Jobs window displays. ...
Toolbar Legends, Toad for Oracle 11.6
Toolbar Legends, Toad for Oracle 11.6
Toolbar buttons and menu icons have been updated in Toad for Oracle 11.6. Their familiar placement will allow you to quickly grow accustomed to the updated images. Toolbar legends Main toolbar Ed...
Customizing Toad for Oracle to Taste
Customizing Toad for Oracle to Taste
A: In version 11, go to Help and search on "customize" or in the Contents, go to: Toolbars, Menus, and Shortcut Keys > Customize Toolbars and Menus. There are six topics on customizing items. Regardi...
How to Setup & Use Toad for Oracle in a Secure Environment
How to Setup & Use Toad for Oracle in a Secure Environment
Let’s face it – it’s a rough and scary computer world we live in today. We have people routinely losing notebook computers with massive local copies of confidential records, computer hackers aggressiv...
Configuring an Oracle Database to have a ‘self-cleaning’ PLAN_TABLE
Configuring an Oracle Database to have a ‘self-cleaning’ PLAN_TABLE
On the database server, go to $ORACLE_HOME/rdbms/admin copy utlxplan.sql to utlxplan.sql.original – you don’t want to lose the original Oracle script. Edit utlxplan.sql and change it to the following...
Toad for Oracle – Queries Q&A
Toad for Oracle – Queries Q&A
Q: Escaping the '_' Character: How do I escape out the '_' character in a query? A: The _ is a wildcard for any single character. You must specify the escaping within the SQLstatement itself. Here's ...
How does the tablespace map work?
How does the tablespace map work?
The tablespace map uses a simplified fragmentation formula. The key points in question: What is the 'sum of the blocks for that segment'? SELECT sum(blocks) FROM dba_extents WHERE tablespace_nam...
Startup Tracing
Startup Tracing
An undocumented (well, up until the help file for Toad 10.6 anyway ) way to trace the amount of time various startup routines take is to edit your TOAD.INI file and add some or more of the following l...
Network Problems connecting with Toad for Oracle?
Network Problems connecting with Toad for Oracle?
Determine your ORACLE_HOME value. The first thing to check is the ORACLE_HOME value. Examine the following key in your Windows registry: HKEY_LOCAL_MACHINE\Software\ORACLE There should be an entry fo...