DBA Lounge

How to Reduce Errors When Managing a Database

Want to reduce the possibility of making errors when managing a database? Hear Pythian founder Paul Vallee give an over view of Pythian’s FIT-ACER check list and see how it helped Pythian reduce errors rate from 1/year of services delivered to 1/ 6.3 years of services delivered.

Setting Up a Home Learning Lab

Thanks to virtualization and cheap, powerful hardware there are a lot of cost effective options available today for setting up a learning environment on your own. In this blog post I will make suggestions on how you can cheaply build yourself an IT Playground, I’ll also talk about some mistakes I made along the way to hopefully save you from adding a few grey hairs.

The Easy Way of Finding Similar SQL Statements

As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!

Statement Toggler for Vim

Wouldn’t it be nice if there was a way to flip block and postfix statements with the ease of a single command? Well, I thought so, so I came up with a dirty little script, have a look.

Set Up Exadata for Cloud Control 12.1.0.2

I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (12.1.0.2). A few documents do exist for this process. However I found a few inconsistencies and problems; I think the existing documents I found were written on older versions of OEM and older versions of the tools. I’m publishing my final procedure here with hopes that it helps you, but as always please cross-reference this with the appropriate documentation before doing anything in your own environment.

Page 8 of 67« First...678910...203040...Last »