Tag: DBA Lounge

Oracle LogMiner Helps Investigate Security Issues

This will help when you need to investigate some past changes to your database when auditing was not enabled. This doesn’t imply that you don’t need auditing. On the contrary, I see no reason not to use it in any and every database. However, often we get systems “as is” and we need a working method now and not the next time it happens.

Read More >

Oracle Support Case Studies

As I was poking around metalink, I found the following extremely interesting section. It’s in a very obvious place, but it’s new, so many of you may have not noticed it. It’s called “Support case studies” and provides some amazing articles.

Read More >

Oracle Patch 10.2.0.3 – Bugs We’ve Seen

When I read Note: 391116.1 with the full list, I noticed the following bugs that we’ve encountered are fixed. Unfortunately, an important bug in 10.2.0.2 posted on the Sept. 29 is not listed as fixed in this patch list.

Read More >

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 .

Read More >

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.

Read More >

Oracle block corruptions, DBV vs RMAN

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every day DBA life.

Read More >

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.

Read More >

Recipes for Creating a Managed Standby with RMAN

Over-the-Top Tales from the Trenches: Bringing order to the chaos of every-day DBA life.

Read More >

Oracle 10.2.0.3 coming soon, and a data guard corruption bug

It looks like Oracle has started testing the 10.2.0.3 patchset. A preliminary list of bugs fixed is at in MetaLink note 391116.1. The “important” bug fixes are here.

Read More >

Basic I/O Monitoring on Linux

Indeed, while the technique we discuss here is basic, it gives a good overview and is very easy to use. So let get focused… We will use iostat utility. There is much to say about IO monitoring and interpreting results. Perhaps this is only the first of a series of posts about IO statistics. At Pythian we often come across different environments with specific characteristics and various requirements that our clients have. So stay tune — more to come.

Read More >
Page 52 of 60« First Page...10...5051525354...60...Last Page »