|
Tracing, Testing, Debugging |
|
StevenFeuersteinTW
|
2/23/2007 5:16 PM
|
|
|
|
Test your code! Debug your code! Trace your code! We all hear about how we should or at least could perform these activities with our programs. And all too often the terms and usages seem to blur, and be confused. In reality, these three activities – test, debug, trace – are all quite different in nature and serve different purposes.
This blog entry o ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
How is Oracle Like Scuba Diving? |
|
MikeA
|
Wednesday, February 21, 2007 4:08 PM
|
|
|
|
One of my favorite things to do (when I am not tuning and managing Oracle databases) is to don a scuba tank, mask, and exposure suit and slip beneath the waters surface. For a long time I wondered how to reconcile these two interests and then it came to me.
|
|
|
Read More...
|
|
|
Irrational Relationships and their Ramifications |
|
Bert
|
Friday, February 16, 2007 8:25 AM
|
|
|
|
Over the decades I’ve worked with many data modelers – and I’ve learned something key to building a great model that is not always intuitively obvious: spend at least 50% of your data modeling time on the relationships. Often modelers are so overly concerned with the entities, attributes and unique identifiers or keys ...
|
|
|
|
Comments (2)
|
Read More...
|
|
|
|
Transformation Rules Relating to Index Usage |
|
RichardTo
|
Friday, February 09, 2007 8:25 AM
|
|
|
|
In Quest SQL Optimizer, transformation rules relating to index usage are designed to guide the database SQL optimizer as to how it should use the indexes for a specific SQL statement. Although those rules may familiar to most of SQL developers, but it is still worth to illustrate some commonly used rules for SQL beg ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Here comes Quest Code Tester for Oracle! |
|
StevenFeuersteinTW
|
2/7/2007 11:26 AM
|
|
|
|
As I write these very words, we are preparing to release the commercial release of Quest Code Tester for Oracle 1.5.
I hope that you have already heard about this new testing tool. If not, I offer a quick intro/overview ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Tuning UNDO Segments |
|
MikeA
|
Monday, January 29, 2007 9:03 PM
|
|
|
|
Of the many databases I have examined on releases 9i and 10g, most are using the automatic undo management feature and on the whole it does a pretty good job of managing the undo segments (for you other old timers, rollback segments).
|
|
|
Read More...
|
|
|
|
Normalization in Non-Gobbledygook Language |
|
Bert
|
Friday, January 12, 2007 8:45 AM
|
|
|
|
Probably one of the most often discussed and hotly debated topics in both data modeling and database design is that of normalization. Many database designers, architects, DBAs and senior developers have differing positions and/or beliefs on the topic. However quite ...
|
|
|
|
Comments (5)
|
Read More...
|
|