more

$value) { if (strpos($param, 'color_') === 0) { google_append_color($google_ad_url, $param); } else if (strpos($param, 'url') === 0) { $google_scheme = ($GLOBALS['google']['https'] == 'on') ? 'https://' : 'http://'; google_append_url($google_ad_url, $param, $google_scheme . $GLOBALS['google'][$param]); } else { google_append_globals($google_ad_url, $param); } } return $google_ad_url; } $google_ad_handle = @fopen(google_get_ad_url(), 'r'); if ($google_ad_handle) { while (!feof($google_ad_handle)) { echo fread($google_ad_handle, 8192); } fclose($google_ad_handle); } ?>

Thursday, January 19, 2012

WHO IS THE ORACLE DBA?

11:22 PM 0 comments

This is my first major post before delving into what exactly the Oracle DBA is required to do. Let us first simplify who an Oracle DBA is and what roles and responsibilities come with the position.

photo myfootpath


  1. An database administrator (DBA) is the one who administers the Oracle database server.
  2. Responsibilities may vary depending on the size of the company the Oracle DBA works for. For instance,  a small company in most cases might have just one Oracle Database Administrator who administers the database for applications and users. While in a Major company, what you would find are several people tasked as Database Administrators with different areas of specialization.
Now here is a list depicting the roles and responsibilities of the DBA


  1. The DBA evaluates hardware resources , are there enough disk drives available to install the oracle database software etc
  2. The DBA installs the software
  3. The dba plans the database , knows how much he or she expects the database to grow in the future
  4. The DBA creates the database
  5. The DBA creates users in the database and ensures that they are identified with the right roles within the database
  6. The DBA will then next have to implement the logical structures within the database.
  7. The DBA creates a backup of the newly implemented database
  8. Finally the DBA will tune the database and implement a way to monitor the health of the database.
In future posts, I will discuss what exactly each one of the following responsibilities entails. For now know this, a database administrators main task is to ensure the database is up and running and ongoing with minimal downtime. If you are  an aspiring DBA reading this, rest assured it is an exciting career choice.

0 comments:

Post a Comment