|
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®
|
 |
|
Comments (1)
|
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 ...
|
|
|
|
Comments (2)
|
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 ...
|
|
|
|
Comments (0)
|
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) ...
|
|
|
|
Comments (4)
|
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.
|
|
|
|
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...
|
|
|