Author Archives: Fred Coulson

Many people have, over the years, both in the blog comments and in private messages, objected to my contention in the Normal Forms tutorial that ITEM_PRICE leads to failure of Second Normal Form. I always go back and forth about … Continue reading →

I am happy to announce that my Three Normal Forms tutorial has been translated into Spanish by Roberto Fernandez. You can download it here.

End-to-end performance tuning is something you hear more and more about. I have seen many presentations about how the “modern” DBA has to be intimately concerned with all layers of the application stack and cannot just focus on the database. … Continue reading →

Here’s a cautionary tale about not doing your homework first. There’s this Oracle 10.2 database on a Windows 2003 server that I manage. I noticed a big hard drive attached to it that was just sitting there unused, so I … Continue reading →

Yesterday I had to shutdown a production reporting database (Oracle version 10.2.0.4) so they could add RAM to the server. The shutdown immediate wasn’t going fast enough to suit me, so I logged into a second session and issued a … Continue reading →

The v$osstat view shows certain OS-level metics such as number of CPUs, current system load, accumulated IO time, etc. Starting in 10gR2, it also records PHYSICAL_MEMORY_BYTES, which is the total size of physical memory on the server. See the documentation. … Continue reading →

I had a little excitement with the cursor: pin S wait on X wait event when a client’s website came grinding to a halt. The first thing I checked was blocking sessions… col username form a12 col event form a25 … Continue reading →

Sometimes I find the need to test disk IO rates, especially in the context of one of those delightful intra-office debates where the DBAs are blaming the lousy hardware for bad database performance and the sysadmins are blaming the lousy … Continue reading →

In Oracle, the standard way to calculate the difference (delta) between two values is using the LAG() analytic function. For example… Suppose you’ve got a table of numeric values– create table t as select rownum id, value from v$sesstat where … Continue reading →