Log Buffer #13: A Carnival of the Vanities for DBAs

Ronald Bradford has published the thirteenth edition of Log Buffer, the weekly review of the database blogosphere. You can learn about Log Buffer and how to get in on the act, on the Log Buffer homepage. It’s good fun, and a fantastic platform for your perspective on the database scene. The schedule is quite open,…

Diagnosing Oracle Performance Problems on *nix

One day I came up with the following neat idea. Start a second listener, on a different port, calling it the emergency listener. Then renice the listener process with higher priority. Now, every time I connect to the database via my emergency listener, my connection gets higher priority, and thus feels like there’s no problem with the database’s resource use.

There is one little caveat however. You need to either have access to root, or have a nice SA that will add renice to your sudoers file .

The Answer to Free Memory, Swap, Oracle and Everything

I have submitted an abstract for my new presentation about linux/unix memory and Oracle to the Rocky Mountain Oracle Users Group for the Training Days in Denver on February 14-15, 2007. I pilot tested it at the Ottawa Oracle User Group in June. The feedback was good and since then I have kept developing the presentation. Soon to be submitted for HotSos 2007.

Using Data as a Tool

IT programs only teach you the programming and software architecture perspective. In DBA work, even when scripting, you have to consider the data as a tool. I’ll show you what I mean.

Page 227 of 247« First...102030...225226227228229...240...Last »