Oracle physical Dba skills

Posted on 2011-10-25
Last Modified: 2013-11-11
What are the oracle physical Dba skills? I really appreciate your time and help in advance
Question by:hussainkhan22
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    They deal mainly with the database and how it performs wiht the server it runs on.  Disk Space, Memory, CPU,  etc..

    Some times even User creation and maintenance.

    Less with application tables, indexes, etc...
    LVL 1

    Expert Comment

    Generally speaking across any database world there are different types of DBAs (, DB architect,  DB analyst, system dba,  application DBA, warehouse admin, performance analyst., DBA developer, etc..)

    To even more categorize this in a broader way, we can say  they all fall either in physical catetory or logical catetory.   The logical DBA is in charge of  developing, design, debugging, etc..  ie the logical  stuff for the database.    The physical DBA the one who is  incharge of configuration, maintenance, physical design, etc.     But some DBAs perform both the activities..
    LVL 15

    Accepted Solution


    Read this :

    a Physical DBA is usually requested to :

    Implement Physical Database Design & Tuning Solns
    Implement Data Management Policies & Procedures
    Implement Data & Database Administration Strategy
    Implement Physical Database Support
    Perform Database Performance Tuning
    Apply Knowledge of Data Migration
    Apply Knowledge of High Availability Solutions
    Apply Knowledge of Log/Backup/Recovery
    Perform Database Creation or Build Oracle
    Perform Database Backup & Recovery-Oracle
    LVL 16

    Expert Comment

    The Oracle DBA required/expected skill-set has grown over the years.
    Perhaps years ago it used to be limited to the Oracle Server, however, experience has shown that the DBA is now expected to know more about the Database engine, the O/S it runs on, the Hardware it runs on in terms of resource usage, such as RAM, Disks and best Disk Array configuration depending on the functionality of the database ie whether OLTP or DDS.
    the DBA now knows about the front end application and how this interacts with the back end database.

    The Oracle DBA is even now expected to know about toher DBMS systems and many shops have a mixture of systems and they want to scripm on costs!!!

    Don't be alarmed, try and be very good in what you know, no matter how limited your skill set and there will be some demamd for your particular skill set.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension ( This reminded me of questions tha…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now