Oracle Tips and Tricks — David Fitzjarrell

January 20, 2012

At The Touch Of A Button

Filed under: General — dfitzjarrell @ 00:25
Tags: , ,

It intrigues me that some DBAs can be lost without tools like Oracle Enterprise Manager or TOAD, so much so that they can’t complete a task without a GUI. What makes this even more disconcerting is these DBAs can execute tasks that they may be unable to complete absent such tools. If what the tool does ‘behind the scenes’ is a mystery to the users it stands to reason that a user, using a GUI, could do some damage to a database by executing misunderstood tasks simply by pressing ‘buttons’.

When I started as a DBA [the earth's crust was still cooling and dirt didn't yet have its official name] there was the command line. That was it. Nothing else. No GUI, no OEM, no slick and nifty applications coded to make DBA life easier. A database was managed at the SQL> or SVRMGR> prompt (depending upon what needed to be done). Pretty graphs didn’t exist, alerts didn’t get generated unless the DBA wrote a script and scheduled it through cron (or the Windows scheduler) to check the database for space or memory or process count and send an email to the DBA should any of the acceptable criteria be violated. Yes, it was a hard life for a DBA, with all of that scripting and manual labor [typing is such back-breaking work]. A DBA had to know what commands did what and when to use them. A DBA also had to know where to excavate performance data, storage numbers, memory usage and user activity from the data dictionary by actually using the manuals and looking things up. Now tools like OEM, TOAD and others make it easy for someone to be a DBA by making most tasks as easy as ‘point and click’, which is a real disservice to the modern DBA, in my opinion.

What if other, daily tasks were modified so that even the uneducated could perform them? Would anyone want someone behind the wheel of a car who didn’t have any instruction at all in how to drive or operate the vehicle? Would anyone want a carpenter, plumber, electrician or mechanic performing any work with the newest power tools but having absolutely no idea how to operate them safely and properly? Clearly no one would want a surgeon operating with the latest gadgets but absent a medical degree. Yet, this is what allows people to be DBAs in the modern world — no knowledge of the intricacies of the database they manage, no knowledge of the commands necessary to perform basic functions such as adding a datafile to a tablespace, resizing a datafile in a database, adding a user account, creating roles, granting roles — the list can go on. Sit them in front of a GUI tool and explain the basics to them (“navigate here, press this button”) and they’re immediately DBAs. The prospect is disturbing.

It’s my privilege to know a number of really good DBAs in this world, DBAs who do know how to create a database, turn on and off archivelogging, restore and recover a database from a reliable backup, how to take reliable backups and do it all from the command line interface. These same DBAs use OEM, RMAN and TOAD to make their lives a bit easier, and I do the same thing so I see no issue with that. I also know (and know of) some DBAs who can’t do the job without OEM or TOAD — I’ve been told this in several interviews I’ve held when looking for additional DBA resources. Some of the most basic questions weren’t answered satisfactorily as I was given step-by-step directions on how to navigate to the page where that particular button resides instead of being told the commands necessary to complete the task in question. In an emergency situation OEM or TOAD may not be available and DBAs who don’t know the command line may be looking for another employer.

It’s my belief that enterprises who train DBAs need to concentrate not only on the tools but on the basic knowledge as well, educating their students not only in OEM but in how to go about managing a database absent those nifty tools. Understanding how the tool works only makes for better DBAs and frees them from being tethered to a graphical user interface, an interface they are dependent upon to perform the most basic and mundane of DBA tasks.

Education and training are demanded by society for teachers, doctors, lawyers, dentists, even insurance agents (not to disparage insurance agents). Why the industry doesn’t demand the same of DBAs is a mystery. [Certification, in many cases, is a requirement on the resume but 'brain dumps' and courses exist to 'train' those uneducated in the chosen DBMS so such 'credentials' can be acquired absent any real work experience. Many of these courses are centered around GUI management tools; sadly the underlying framework is glossed over in deference to learning to navigate the chosen graphical interface. Such an environment produces, in the Oracle arena, Oracle Certified Professionals completely absent any professional experience.] Yes, experience counts but if that experience is nothing more than a set of rote instructions on how to navigate a GUI tool how much worth does it bring to the employer? Not much, really.

Database administration is a respected profession, and most DBAs in the workforce are qualified and capable. Occasionally a few get through who meet the description I’ve given here. It’s those few I write about, and ask that they further their education and learn how their chosen DBMS works and how, in an emergency, to do their jobs absent any flashy graphic tools.

I don’t believe that’s too much to ask.

About these ads

5 Comments »

  1. Interesting to see all the job ads that list as requirements proficiency in 'tool X' but nothing about ability to design and implement data recovery and security policies or maintaining specific levels of high availability.SVRMGRL – the good ole days :)

    Comment by thatjeffsmith — January 20, 2012 @ 13:23 | Reply

  2. So True! I'm also from post-svrmgrl era but was fortunate to have a top dba of the calibre you mentioned, who put me in good stead with cmd lines. Years on , and a couple of total power outages down the track, just a keyboard and fingers are still the ace up the sleeve! Thanks for the memories….

    Comment by Anonymous — March 22, 2012 @ 00:07 | Reply

  3. I can’t live without my scripts and sqlplus, my day to day is a black screen.
    Regards

    Comment by Antonio — August 22, 2012 @ 15:11 | Reply

  4. How true! It’s about “NUTS-AND-BOLTS” or “POINT-AND-CLICK” DBAs. I also can’t live without my scripts and sqlplus and I have seen how much damage the “POINT-AND-CLICK” DBAs can do! I use Toad only to read databases, e.g. getting procedures source code rather than messing around with DBA_SOURCE, etc. Any DDL or even DML I perform via sqlplus only with full control of commit/rollback, etc. I have seen terrible thing the early versions of Toad doing to the database due to bugs (I bet they have all been fixed by now but I am not going to test it :)

    Comment by Alex Mamyrin — October 4, 2012 @ 10:23 | Reply

  5. Thanks for sharing this. It matches my position exactly. I am 100% a GUI user, well, because I think my brain is too full to memorize all the syntax of the world. But I test, test, test. And I study those tools and options. I know the trade-offs. And I never* just point a GUI at a production server. How does one do test and deploy that way?

    Comment by karenlopez — March 14, 2013 @ 10:37 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 675 other followers

%d bloggers like this: