I just want to raise a warning flag for DBAs using RMAN and flash recovery area in Oracle 10g. The lesson is, to avoid backing up archivelogs that have already been backed up when using plus archivelog in a backup script, make sure you enable RMAN optimization.
Welcome to the 44th edition of Log Buffer, the weekly compendium of database blogs. This one’s a grab-bag. Let’s start with some Oracle stuff this week.
This is more of an essay than a blog post, but this subject comes up time and again, and since I tripped across this interesting blog post by Pedro Timóteo about why he has decided not to be a sysadmin any more, I thought now’s as good a time as any to comment on what I think is a significant industry trend in production engineering work.
Welcome to the 43rd edition of Log Buffer, the weekly review of database blogs.
Several months ago, I started to once again drink that elixir of the Database Gods. Now that I am beginning to drink coffee again, I can really appreciate Jon Emmons’s humor in naming his blog site www.lifeaftercoffee.com. Truly, a DBAs work life does NOT begin until after coffee.
I chose to talk about a technique I used at a client’s site to report the topmost space-wasting objects in an Oracle database. I was looking for a way to detect these objects without having to run some expensive analyze statements or dbms_stats jobs. I found out that I can use the dbms_space package to do this. It worked very well for me and I’m sure lots of DBAs could use this technique too.
Number 10? I only just finished Dirty Dozen #1. What’s going on here, then? Well, no one said I had to write them in any particular order! But, if you look at the posters, they are clearly numbered. Should someone else pick up the Dirty Dozen challenge, it will help them to see which ones…
I first presented on Oracle 10g Block Change Tracking Internals at UKOUG 06 in Birmingham. It was very well received, but there were quite a few gaps in my knowledge, and I later discovered I was incorrect in some places. I’ve done some additional research, filled in the blanks and corrected in a few places. Download it here.
Looks like our blog has turned into a MySQL blog over this week, so I have to do something about it. Luckily, I have zillions of pending posts, so I’ll start with posting my presentations materials from this conference with my remarks on how it went in general.
Beth Breidenbach, having braved a week thick with posts from the MySQL Conference, has published the 42nd edition of Log Buffer, the weekly review of database blogs, on Confessions of a database geek.