|
|
|
|
Toad Executing Scripts against Multiple Databases (Part 1) |
|
Bert
|
Tuesday, July 29, 2008 3:15 PM
|
|
|
|
One of the more frequent questions people ask me is why can’t Toad run scripts or commands against multiple databases at once? Of course as usual the answer is Toad already can – so I’m going to dedicate the next couple weeks’ blogs to this topic.
This week I’ll highlight the first method of running scripts for multiple databases using the “Toad Script Manager”. It ...
|
 |
|
|
Read More...
|
|
|
Toad Data Modeler Generates Best SQL |
|
Bert
|
Wednesday, July 23, 2008 5:11 AM
|
|
|
|
When you go through the entire exhaustive process of doing an effective (i.e. accurate) logical model so that you have properly captured all the true business rules and requirements, you sure don’t want your data modeling tool to compromise those findings as you move into the physical model – which is database platform dependent. Yet most data modeling tools do a very poor job of translating ...
|
|
|
|
|
Read More...
|
|
|
Only Toad can debug SQL Scripts |
|
Bert
|
Wednesday, July 16, 2008 3:45 AM
|
|
|
|
I have been doing Oracle work for just over two decades – and I’ve probably written thousands of SQL scripts. Many of those were DBA oriented in their task nature, but even application development presents times where SQL scripts are used. For example, the need may arise for the operating systems’ or third party schedulers to invoke a shell script to execute a SQL script to execute ...
|
|
|
|
|
Read More...
|
|
|
Toad and Dynamic SQL Scripting |
|
Bert
|
Wednesday, July 09, 2008 7:02 AM
|
|
|
|
Sometimes, even in today’s world of super GUI’s, a SQL script is still the best way to do something. Plus there are always those people who steadfastly prefer command line to GUI’s no matter what. Can Toad accommodate and even facilitate these needs? Of course you know that the answer is a resounding yes.
Let’s sa ...
|
|
|
|
|
Read More...
|
|
|
Toad Data Modeler Hits a Home Run!!! |
|
Bert
|
Wednesday, July 02, 2008 5:28 AM
|
|
|
|
I have always believed that Toad Data Modeler offers the best, easy to use data modeling tool on the market for the money. Now my faith has been confirmed – others are starting to see just what a gem Toad Data Modeler. Take a look at this review. I agree 100% of course – but everything there is true.
|
|
|
Read More...
|
|
|
Making Toad Do What You Want |
|
Bert
|
Wednesday, June 25, 2008 8:55 AM
|
|
|
|
A lot of times people will ask Quest tech support or via our Yahoo discussion groups how to make the editor run SQL commands and do stuff more like SQL*Plus or how to better control the output look and feel (i.e. behavior). Along those lines and another very popular question is where one can set an option in Toad for the editor to do something specific (e.g. turn off feedback, etc) – because they have ...
|
|
|
|
|
Read More...
|
|
|
ODTUG Post Mortem |
|
Bert
|
Thursday, June 19, 2008 5:22 AM
|
|
|
|
There are quite a few blogs out there about what happened or what’s new from this week’s ODTUG conference in New Orleans. So rather than restate what many others are reporting, I thought I’d try a slightly different approach – to instead report more on what was noticeably absent or different this year. J
|
|
|
|
|
Read More...
|
|
|
The Database “Big Easy” |
|
Bert
|
Wednesday, June 11, 2008 5:43 AM
|
|
|
|
Next week the annual ODTUG conference will be held in New Orleans. I’ll be attending sessions and visiting vendor booths in order to stay current with the database DBA and development markets (more developer oriented at this particular show). I’ll report my findings and things of interest next week. I especially hope to corner some Oracle folks on the 11g R2 beta – which I&rsqu ...
|
|
|
|
|
Read More...
|
|
|
How about a free copy of Toad DBA Suite for Oracle? |
|
Bert
|
Friday, June 06, 2008 5:20 AM
|
|
|
I’m working with our product team to develop a novel idea – and need feedback from you, our customer base. So here comes what may seem like a silly question: How would you like to win a free copy of the Toad DBA Suite for Oracle?
Let me explain. I’m proposing that we sponsor an Oracle ...
|
|
|
|
|
Read More...
|
|
|
Database Benchmarking Preparatory Checklist |
|
Bert
|
Wednesday, May 28, 2008 4:20 AM
|
|
|
|
There have been several papers and blogs from Quest on the issues of benchmarking successfully, however the condition persists where people experience trying issues with Benchmark Factory and obtaining satisfactory benchmark results. I still maintain that it’s primarily attributable to a lack of proper and complete precursory work. But people generally seem to need more than a notice to prepare more, ...
|
|
|
|
|
Read More...
|
|
|
ODTUG is just around the corner |
|
Bert
|
Wednesday, May 21, 2008 3:50 AM
|
|
|
|
It’s that time of year once again. The Oracle Developer Tool Users Group (ODTUG) is quickly approaching (June 16th-19th in New Orleans – see below). For Quest, this is a really great show. It’s very well attended by and representative of our Toad customer base. It’s not uncommon for a vast majority of this show’s att ...
|
|
|
|
|
Read More...
|
|
|
Toad Saves Mucho Dinero |
|
Bert
|
Wednesday, May 14, 2008 4:15 AM
|
|
|
Sometimes people will compare Toad against low cost competitors or freeware (remember, Toad offers a freeware version as well). The idea being that one can save money by going with a lesser product. That seems fiscally responsible – until you do the math that is. So, let’s work a simple exam ...
|
|
|
|
|
Read More...
|
|
|
Yet another Little Toad Gem |
|
Bert
|
Wednesday, May 07, 2008 5:23 AM
|
|
|
There are so many useful little make or break features inside Toad, it’s very often difficult to pick one to highlight. A few weeks ago I started to divulge some things coming in Toad 9.7 (and already in the beta). One item I ment ...
|
|
|
|
|
Read More...
|
|
|
How Data Modeling Can Save Money |
|
Bert
|
Wednesday, April 30, 2008 4:46 AM
|
|
|
|
It’s not uncommon to discover databases that have simply evolved over time rather than having been built according to some overall design or “master plan”. And there seem to be no shortage of answers as to why this occurs. Sometimes DBA’s are just far too busy with a myriad of other tasks. Sometimes developers are under th ...
|
|
|
|
|
Read More...
|
|
|
Toad Can Reduce Waits |
|
Bert
|
Wednesday, April 23, 2008 3:46 AM
|
|
|
|
When using either Toad’s Stats Pack Browser or AWR Browser screens (both part of the optional DBA module and/or bundle), the plethora of graphs can sometimes be a wee bit overwhelming – as shown in the screen snapshot below. So how is any DBA in an urgent situation or hurry to both successfully and expediently interpret such database activity?
...
|
|
|
|
|
Read More...
|
|
|
Toad Fits Like a Glove |
|
Bert
|
Wednesday, April 16, 2008 5:42 AM
|
|
|
|
I’ve seen some people on competing product discussion boards say things like Toad’s schema browser Is far too bloated – with too many tabs and images sucking up all the precious real-estate. But like anything else in Toad, if you don’t experiment with and utilize all the cool options it offers – you could very easily arrive at this quite mistaken conclusion. So ...
|
|
|
|
|
Read More...
|
|
|
|
Toad – What Next? |
|
Bert
|
Wednesday, April 02, 2008 8:34 AM
|
|
|
Recently, my Toad World blog asking whether we needed to update the Toad Handbook generated as many or more replies than all my other past blogs combined. So it obviously seems best to ask you guys – our customers and users – for more opinions and ideas. |
|
|
|
|
Read More...
|
|
|
Toad Should be a No-Brainer |
|
Bert
|
Wednesday, March 26, 2008 5:10 AM
|
|
|
|
I often get asked by both new and exiting customers to aid them in the cost justification process for purchasing Toad or upgrading their licenses. I thought since I get asked this so often, maybe a short blurb on the topic would be generally beneficial.
To write this blog, I’m using Microsoft Word. When I’m done, I’ll be em ...
|
|
|
|
|
Read More...
|
|
|
Toad does RAC – Really |
|
Bert
|
Wednesday, March 19, 2008 5:08 AM
|
|
|
|
An increasingly common question these days is does Toad support Oracle RAC (i.e. Real Application Clusters)? And if so – how, when and where?
HOW: There ...
|
|
|
|
|
Read More...
|
|
|
|
Database Version Control via Toad |
|
Bert
|
Wednesday, February 27, 2008 9:01 AM
|
|
|
|
One key task for many DBAs is maintaining a database version control or change revision history. Database version control affords the DBA the ability to restore the database to any prior state, or to detect unplanned database revisions that cause the database to be out of compliance with its specification. One could argue that the latter scenario would unlikely happen in a well controlled production environment ...
|
|
|
|
|
Read More...
|
|
|
Toad Database Probe Customization |
|
Bert
|
Wednesday, February 20, 2008 8:54 AM
|
|
|
|
Did you know that Toad’s Database Probe screen is customizable? That’s why it’s vastly superior to the simple Database Monitoring screen. Here’s a basic screen snapshot:
 < ...
|
|
|
|
|
Read More...
|
|
|
Toad and Monitoring Indexes |
|
Bert
|
Wednesday, February 13, 2008 10:11 AM
|
|
|
|
Ever wonder which indexes are being used in your database? Well Oracle 9i introduced the capability to track index usage. But you had to learn new ALTER INDEX command syntax to support this and then how to query V$OBJECT_USAGE view to see the index usage information. Well I’m too darn lazy, and why not be – as with most things in Oracle, Toad cleanly exposes this feature and increases its us ...
|
|
|
|
|
Read More...
|
|
|
Toad Dynamic SQL Scripting |
|
Bert
|
Wednesday, February 06, 2008 7:36 AM
|
|
|
Sometimes people will request that Toad have a certain special new feature, often special to the task at hand which they’re trying to accomplish. Keeping in mind my recent Toad blog about SQL*Plus compatibility, there are very often easy ways to use existing Toad features to do what the ...
|
|
|
|
|
Read More...
|
|
|
Toad and SQL*Plus Compatibility |
|
Bert
|
Friday, February 01, 2008 12:17 PM
|
|
|
|
Sometimes people will ask why can’t Toad work more like SQL*Plus – and the funny thing is the answer is quite often it does. You really just need to know how SQL*Plus works – and then look for the same feature within Toad. Let’s take a very, very common scenario that gets asked almost every quarter. Look at my SQL*Plus SELECT command in the screen snapshot below. Suppose ...
|
|
|
|
|
Read More...
|
|
|
|
Toad’s New & Improved Database Browser |
|
Bert
|
Thursday, January 03, 2008 11:08 AM
|
|
|
|
There are many different types of Toad® users, and since job titles and descriptions vary so widely, it’s tough to say a typical Toad user looks like this and thus needs this. Thus Toad has evolved over time to meet the ever growing needs of our customers. Quest has two key Toad Yahoo discussion groups to fa ...
|
|
|
|
|
Read More...
|
|
|
Speed Up Toad |
|
Bert
|
Monday, December 17, 2007 1:20 PM
|
|
|
|
It’s not uncommon for software to increase in install size and memory footprint over the years – and Toad®
|
|
|
|
|
Read More...
|
|
|
Super & Sub Type Option #1 |
|
Bert
|
Friday, November 30, 2007 3:50 PM
|
|
|
|
When we create a super-and-sub type (a.k.a. Inheritance) entity relationship in a logical data model, it’s very clear what the business requirements being communicated are – that different subsets of attributes comprise the “cumulative entity” being modeled depending upon the business context. &l ...
|
|
|
|
|
Read More...
|
|
|
Oracle 11g on a notebook: Tread Lightly |
|
Bert
|
Friday, November 16, 2007 10:41 AM
|
|
|
|
This blog posting is not meant to demean or slander the Oracle database in anyway. I’ve staked almost my entire career on Oracle technologies – and I intend to finish these last 7-10 years doing more Oracle stuff. To quote a funny Saturday Night Live skit: “Oracle has been very, very good to me.” So my comments are mo ...
|
|
|
|
|
Read More...
|
|
|
Expedite Saving Data via Toad |
|
Bert
|
Tuesday, November 06, 2007 8:14 AM
|
|
|
|
Probably one of the most useful and frequented tasks performed with Toad® for Oracle is saving data to a file, such as comma delimited text (or any of the other numerous formats supported). It’s a relatively easy feature to find – you simply depress the “right hand mouse” (RHM) ...
|
|
|
|
|
Read More...
|
|
|
Oracle Parallel Query Abuse |
|
Bert
|
Wednesday, October 31, 2007 6:46 AM
|
|
|
|
Oracle’s Parallel Query Option (PQO) is a fantastic tool, but much like any good tool, it can very easily be used in the wrong situation or simply abused. In those cases, PQO can actually make database performance much worse. Let’s examine some common misuses or misperceptions regarding optimal and efficient PQO usage.
|
|
|
|
|
Read More...
|
|
|
Running Toad on Linux! |
|
Bert
|
Monday, October 22, 2007 4:09 AM
|
|
|
|
OK – now that I grabbed your full attention with that snappy title, let’s see just how to run the Toad® on your Linux desktop or notebook. Let’s say that you’re running Redhat, CentOS, SuSE or Ubuntu Linux on your PC, let’s further assume that you would like to run Toad either ...
|
|
|
|
|
Read More...
|
|
|
|
Toad Sometimes Slow on Oracle 10g? |
|
Bert
|
Tuesday, October 02, 2007 9:44 AM
|
|
|
|
Often people will write or call to relate that Toad® seems sluggish when working against Oracle 10g databases – and that creating new connections in particular seems to take an unreasonably long time. They are often especially frustrated since this problem did not occur with Oracle versions prior to 10g. So what is T ...
|
|
|
|
|
Read More...
|
|
|
Toad Subsets Data |
|
Bert
|
Monday, September 24, 2007 7:43 AM
|
|
|
|
A common task for DBAs is to create a test or development environment that has a subset of production data for testing and development purposes. As usual, Toad
|
|
|
Read More...
|
|
|
|
Toad Simplifies ANSI Joins |
|
Bert
|
Tuesday, September 04, 2007 4:06 AM
|
|
|
|
Starting with Oracle 9i, Oracle recommends that SQL developers use the ANSI join syntax instead of the Oracle proprietary (+) syntax. There are several reasons for this recommendation, including:
|
|
|
|
|
Read More...
|
|
|
Oracle 11g Introduces Invisible Indexes |
|
Bert
|
Monday, August 27, 2007 6:09 AM
|
|
|
|
As I wrote last week, Oracle 11g has a plethora of really great new features. One that should really hit a home run with data warehousing DBAs is “Invisible Indexes.” The name is not a joke – they are exactly what they say. An invisible index is ignored by the query optimizer when forming an explain plan for a SELECT statement, ...
|
|
|
|
|
Read More...
|
|
|
Oracle 11g Improves Partitioning |
|
Bert
|
Tuesday, August 21, 2007 4:21 AM
|
|
|
|
Oracle 11g has a plethora of great new features. One area that has improved with each of the last four releases has been partitioning, i.e. the method to break larger tables into smaller, more manageable and efficient sub-tables. While it was originally touted as a boon for just the data warehousing world, partitioning no ...
|
|
|
|
|
Read More...
|
|
|
Oracle 11g Adds Virtual Columns & Indexes |
|
Bert
|
Wednesday, August 15, 2007 6:18 AM
|
|
|
|
Oracle 11g is out for Linux – and like every new release, there’s tons of cool new stuff. So over the next few weeks, I will write about some of Oracle 11g’s new features. This week, I’ll look at Virtual Columns and Virtual Indexes.
|
|
|
Read More...
|
|
|
What is Oracle ASM and does Toad for Oracle support it? |
|
Bert
|
Wednesday, August 08, 2007 5:35 AM
|
|
|
|
We all know that “a picture is worth a thousand words,” so I provided a few pictures (shown below) to try and briefly yet succinctly explain what ASM is and how it’s different than the previous ways of managing disk space within Oracle.
|
|
|
Read More...
|
|
|
DBA Hardware Options “Over the Years” |
|
Bert
|
Thursday, August 02, 2007 6:55 PM
|
|
|
|
Ever hear people say they miss the good ole days – when times and things were much simpler than now? Well the same is true for Oracle DBAs, the early 90’s (circa 1993) were much simpler in terms of hardware selection for an Oracle server as summarized below.
|
|
|
|
|
Read More...
|
|
|
Toad Database Tune and Optimize Check-List |
|
Bert
|
Monday, July 23, 2007 6:53 AM
|
|
|
|
I use Toad® for Oracle almost everyday to tune and optimize problematic databases for customers, partners and friends. And I noticed that I followed a pattern – which seemed consistent across all such attempts. And although I wrote the whitepaper “
|
|
|
Read More...
|
|
|
Welcome to the new TPC-E Benchmark |
|
Bert
|
Monday, July 16, 2007 10:48 AM
|
|
|
|
One of the most widely recognized and often quoted database benchmarks is the TPC-C. For over 14 years, the TPC-C has been the industry standard OLTP test; however, it’s very clearly showing its advanced age. The TPC-C does not adequately mimic today’s ...
|
|
|
|
|
Read More...
|
|
|
Switching Data Modeling Tools? Ouch! |
|
Bert
|
Monday, June 25, 2007 7:52 AM
|
|
|
|
Probably the single most painful task in data modeling (or any modeling for that matter) is switching tools. Forget the high direct costs like purchasing licenses and the obvious indirect costs of retraining your staff, because it’s the migration of all your meta-data from one tool to the other that looms large on t ...
|
|
|
|
|
Read More...
|
|