RE: Oracle Job Task Analysis
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 databaseapplications 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
RE: Oracle Job Task Analysis
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 [EMAIL PROTECTED] 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
Re: Oracle Job Task Analysis
Scott, This is quite a list you have compiled. I wouldn't subtract anything. The only thing I could think of to add was in the Scalability section. This section seems to concentrate on using Oracle technologies to enhance scalability, but there is another level that I think needs to be considered as well. The ability to scale ( or not ) is built into an application. An app that calls 'select something from dual' in every transaction is going to have problems. So will apps where the developers insist on trying to do everything in code rather than relying on the database. A DBA should be able to recognize when this is happening. The best course is to have an adivisory position in this regard when an app is being developed. Doesn't often happen this way though. A DBA should be able to demonstrate common developer habits that inhibit scalability, and how to recode these so that they are more scalable. Being able to do so in PL/SQL is sufficient, and in fact preferable. Any chance of us seeing the completed analysis? Jared Scott [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/01/2003 01:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle Job Task Analysis 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 ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Oracle Job Task Analysis
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 databaseapplications 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 10. Communicate with users about problem resolution and proper system usage H. SCALABILITY 1. Demonstrate an appreciation of Real Application Clusters Architecture Scaleup and Speedup capabilities 2. Demonstrate an Appreciation of Shared Server Architecture 3.Demonstrate an