John, That is a good question. What is the purpose of
this task Analysis?
I am trying to see what most DBA's perceive as what is
the most important things to learn so you can manage
an Oracle Database.
An example would be Learning Oracle Architecture. If
you are a small, medium or large company, Architecture
is probably the most important.
Within the Oracle Architecture what is the most
important for me to learn to job.
Learning the SGA structures and how to size them.
Learning the physical structures of the database and
how to manage them.
So if you wanted to be a DBA with Oracle what major
Oracle components do think you need know to accomplish
that job and what sub-components are important?
If I was a DBA in a company that does a lot of interne
t activity what do I need to know? If I run a 7X24
shop what do I need to know and so on.
Small, medium and Large companies will require a base
knowledge and as you get more niche you will need to
understand other components of Oracle. We also need to
look at what is niche. RAC is niche but becoming more
mainstream. What do I need to know to run a HA shop,
however Context, XML and Spatial are in the database,
while these are niche they are as common as RAC.
So what I am looking for is what people perceive to be
the most common components needed to do their Job.
Another interesting question is do I need to learn how
to create the database and other database objects
using manual methods or do I use DBCA and EM to do my
job. Is knowing the GUI sufficient for me to be a DBA?
These are why I am asking these questions. I really
want to know what you really need to know right down
to you only need to know it if you implement the
option.
Does this help?
Scott
- "Hallas, John, Tech Dev"
<John.Hallas_at_gb.vodafone.co.uk> wrote:
> Scott,
> Is this job task analysis menat to be specific to
> what you do/ will do at your current site or to
> cover general activities thta a DBA may come across.
>
> If it is the first option it appears that you are
> covering almost every Oracle feature available so
> you must be very busy.
> If it is the second option then I suspect very few
> DBAs could honestly say that they have worked and
> know well every task on the list and indeed would
> not get chance to use them all at any one site.
>
> However a key word in the list is *understand*. That
> means different things to different people. These
> could be grouped by
> 1) Deeply understand , have used extensively, raised
> bugs on the product etc
> 2) Have read up on and not all about in principle
> and would expect to implement with no great
> difficulty
> 3) Have heard of and not much else
> 4) Those who can talk bulls* and are at stage 3 but
> are at level 1 at the CV stage.
>
> Overall I think I am asking 'what is the purpose of
> this task list'
>
> John
>
> -----Original Message-----
> Sent: 01 April 2003 22:14
> To: Multiple recipients of list ORACLE-L
>
>
> I am putting together a prelimanary job task
> analysis
> for Oracle DBA's and would like some input from you
> hardworking DBA's on this list.
>
> Here is what I have so far for core competencies and
> I
> would like to add or subtract from this list based
> on
> your input.
>
> A. Oracle Architecture And Options
> B. Security and Network Access
> C. Application Design and Modelling
> D. Backup And Recovery
> E. Software Maintenance And Operation
> F. SEGMENT and DATA MANAGEMENT
> G. Tuning And Troubleshooting
>
> My Recommendations for slightly more advanced
> competencies that are still quite important
> For many installations.
>
> H. Scalability
> I. High Availability
> J. Business Intelligence
>
> Here is what I have as sub-components for the core
> competencies.
>
> A. ORACLE ARCHITECTURE AND OPTIONS
>
>
> 1. Demonstrate an understanding of memory
> structures
> and processes which make up an Oracle instance
> 2. Demonstrate an understanding of the logical and
> physical structures associated with an Oracle
> database
> 3. Demonstrate an understanding of PL/SQL
> constructs
> (triggers, functions, packages, procedures) and
> their
> processing
> 4. Demonstrate an understanding of distributed
> architecture and client server and 3 tier
> architectures
> 5. Demonstrate an understanding of Oracle
> Globalisation
>
>
>
>
> B. SECURITY and NETWORK ACCESS
> 1. Create, alter, and drop database users
> 2. Develop and implement a strategy for managing
> security using roles, privileges, authentication,
> 3. Demonstrate an Appreciation of implementing row
> level security using Application Contexts and Fine
> Grain access control
> 4. Demonstrate an Appreciation of implementing
> Network security using Oracle Internet Directory
> (OID)
> ,LDAP and Single Sign On (SSO)
> 5. Demonstrate an Appreciation of implementing
> firewalls in Oracle using Standard Oracle Net
> features
> 6. Use Database and Fine grain auditing
> 7.Demonstrate an understanding of the implications
> of
> distributed
> processing on the security model
>
>
>
> C. Appication Design and Modelling
> 1. Implement the physical database from the logical
> design
> 2. Understand the benefits of using stored
> procedures
> and constraints to
> implement the application
> 3. Maintain familiarity with the structure and
> characteristics of database applications
> 4. Manage the bulk loading of data with SQLLDR
> 5. Manage Data transfer or reorganisation using
> EXPORT/IMPORT
>
>
> D. BACKUP AND RECOVERY
> 1. Understand Oracles Recovery Structures and
> Architecture
> 2. Understand the Functionality of RMAN and its
> benefits
> 3. Develop a suitable backup, restore and recovery
> Strategy
> 4. Understand and implement multiplexed control
> files
> 5. Understand and implement redo log groups and redo
> log members
> 6. Perform backups of databases and tablespaces
> with
> and without RMAN
> 7. Perform restores and recoveries with and without
> RMAN both complete and incomplete
> 8. Perform Block Media Recovery (BMR) with RMAN
> 9. Perform test recovery
>
>
>
>
> E. SOFTWARE MAINTENANCE AND OPERATION
> 1. Install and upgrade Oracle and supporting
> products
> using the Oracle Universal Installer and various
> maintenance tools
> 2. Configure the Oracle instance using init.ora or
> SPFILES and OMF
> 3. Create a database with or without OMF
> 4. Distinguish among Instance startup and shutdown
> options
> 5. Configure and Manage Listeners and client naming
> methods using Oracle Net
> 6. Demonstrate an understanding of the capabilities
> of underlying
> operating systems and File Systems as they relate
> to
> the Oracle database
> 7. Manage maintenance contracts and support
> agreements
>
>
> F. SEGMENT and DATA MANAGEMENT
> 1. Understand and Implement tablespaces - locally
> managed and dictionary managed and their datafiles
> 2. Understand the benefits of automatic segment
> space
> management
> 3. Understand and Implement the various types of
> Segments in Oracle for storing Table data, including
> Tables,Clusters, IOTs, External Tables
> 4. Understand and implement different Index options
> available in Oracle including B*Tree, Bitmap,
> reverse
> key, and function based
> 5. Implement integrity constraints
> 6. Understand the implementation of Workspace
> Management for table Versioning
>
>
>
> G. TUNING AND TROUBLESHOOTING
> 1. Use data dictionary and Dynamic Performance views
> to Monitor the Database and the Instance
> 2. Collect and analyze relevant database
> performance
> information
> 3. Identify and implement appropriate solutions for
> database performance problems
> 4. Diagnose and resolve locking conflicts
> 5. Diagnose Oracle Net problems
> 6. Perform capacity planning
> 7. Control system resource contention using the
> Oracle Resource Manager
> 8. Implement profiles to limit resource consumption.
> 9. Use vendor support services when necessary
>
=== message truncated ===
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott
INET: oraracdba_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Apr 02 2003 - 09:03:37 CST
