Blog Aggregator - Amardeep Sidhu

Database administrators are ultimately responsible for guaranteeing the quality of their organization’s database environments. From protecting against unauthorized access to providing 24×7 availability – “the buck stops at the DBA Unit.” Although the database infrastructure (DB binaries, O/S, hardware) doesn’t change much, there is one component that usually changes a lot – the application. This blog provides readers with helpful hints and tips on application change management best practices.

A thought just crossed my mind. I wonder if there is a market for short (one day) task oriented training for the sort of things that aren’t normally covered in general courses.

For example I’m aware that there are training courses that mention standby databases and certainly there are courses that cover RMAN, at least for basic backup and recovery. I’m not aware of any that actually take you

We are going to cover a lot of different topics in the next few blogs. The information will range the spectrum, from keeping our environments organized and uncluttered to backup and recovery best practices.

This blog will focus on the most important responsibility we are charged with as DBAs - ensuring that our organization’s databases can be quickly and easily recovered.

Let’s continue our discussion on the Non-Technical Art of Being a Successful DBA. The intent of this blog is to help administrators design and standardize on a formalized design review process. The goal of the design review process is to identify and address application design, process flow, program logic and SQL statement problems early in the development lifecycle. Identifying these issues early in the development lifecycle allows them to be more easily addressed than if they were to be identified during later stages.

Zsolt Lajosfalvi wrote such an interesting comment in response to my earlier post about PL/SQL Procedure Call Overhead that I felt it deserved its own space.

What follows is exclusively the work of Zsolt. My results from verifying his tests follow at the end.

Zsolt:

In my experience the overhead of PLSQL procedure invocations is so small that you’ll most probably never have to think about it

Doug Burns recently posted in his journal a list of common search terms that people have used where his journal appeared in the results. I figured I’d post mine (according to Statcounter.com). Fortunately (or unfortunately) mine are not anywhere near as exciting as his.

Perc. Search Term
5.80% ora-07445
4.35% orapwd invalid username password
2.90% exception signal: 11 oracle
2.90% alter user

I absolutely and firmly believe that Data Administrators are the unsung heroes of the Information Technology profession. This blog will be shorter than most. The reason is that I don’t consider myself qualified to instruct others in the Data Administration function. I will state that after twenty years of working as DBA, I can perform the basic functions fairly well when I need to. The intent of this blog is to provide readers with a launching point to start their education and stress the importance of effective data resource management.

Héctor Rivera MadridOracle Certified MasterOCP DBA since 7.3