 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
Bert |
Created: |
Monday, October 30, 2006 2:02 PM |
 |
|
Providing useful “how to” and “tips and tricks” covering topics such as database admin and development best practices, Toad for Oracle feature insights, and Toad Data Modeler topics.
|
|
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.
|
 |
|
Comments (0)
|
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 ...
|
|
|
|
Comments (0)
|
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 ...
|
|
|
|
Comments (2)
|
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
|
|
Comments (1)
|
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:
|
|
|
|
Comments (0)
|
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, ...
|
|
|
|
Comments (0)
|
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 ...
|
|
|
|
Comments (0)
|
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.
|
|
Comments (3)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|