Setting up a Successful Test System in Oracle
Let’s continue our discussion on the 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 life cycle allows them to be more easily addressed than if they were to be identified during later stages. That last statement bears repeating. Like any other issue you face, no matter what it is (personal, professional, whatever), the sooner you identify it, the easier it is to correct.
Our blog has received a 7.8 out of 10 “Very Good” rating from the editors at Blogged. The Editor reviews are provided by professional editors who evaluate a blog based on: Frequency of Updates, Relevance of Content, Site Design and Writing Style.
I absolutely and firmly believe that Data Administrators are the unsung heroes of the Information Technology profession. This blog will be shorter than most of the upcoming blogs you will see from me. As a writer, I’m not noted for “keeping it brief”. I used to be an Oracle instructor and I like to pack as many facts as I can into these things. After reading a few of my upcoming blogs, you’ll probably agree.
Ever fumble around at 2 AM looking for that SQL statement you wrote a while back? You know, that one special script that will give you just the information you need to solve the problem and go back to bed? I must admit, I have done my fair share of moonlight script hunting. This blog will provide you with a few recommendations on naming convention best practices.
Let’s start our series on Art of Being a Successful DBA by covering the art of good documentation. Although the importance of a well thought out and detailed documentation library is blatanly obvious, creating documentation is the task most often postponed by an overworked DBA unit.
One of the benefits of my 20-year career (I think) is that most of the jobs I have held can be described as somewhat “unforgiving”, shall we say… What these jobs taught me is that I needed more than just technical expertise to become successful in my chosen profession. I quickly learned that becoming proficient at the various disciplines I will be discussing in upcoming blogs was just as challenging to me as honing my technical skill sets.
You got the job because you’re a quick learner, have the ability to understand complex systems, and most importantly, you can troubleshoot. However you became an Oracle Apps DBA, you’re one now, so the fun starts. I started this blog to assist young Oracle Apps DBA professionals who might need a little more detail in their solutions and good discussion into basic, fundamental Oracle architecture and other Oracle App subjects.
As the modern database continues to evolve and take on a more strategic role in business, the complexities associated with managing these environments grows as well. For database administrators, this changing landscape forces them to continuously adapt and grow alongside the database engine to properly design, support, and secure an enterprise’s critical data stores. Their in-depth knowledge of the infrastructures so crucial to operations make DBAs an integral part of not only day-to-day functions, but business decisions aimed at reducing operation costs, improving margins, and more.