Computer Courses from, Keimos - IT Training Services

Computer Training Courses Spacer image

IT Training Courses Spacer image
Customised IT Training for

Individuals, IT Professionals and Businesses

To talk to us, Call 01492 623887

  
Not found what you are looking for then search the full catalogue of courses
Oracle Approved Courswear

Oracle9i Performance Tuning

The Oracle9i Performance Tuning Curriculum introduces students to the strategies and techniques used for tuning the Oracle9i server and the importance of good initial database design. This curriculum will cover how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views, migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting are also covered in this curriculum.

Audience

The intended audience for this curriculum includes Database Administrators, Technical Support Professionals, and System Administrators.

Course Curriculum


Strategies and Techniques

This first part of the course introduces you to the strategies and techniques used for tuning the Oracle9i server.

Learn To

. Match the tuning goals with the appropriate job role.
. Identify common tuning problems that directly affect database performance.
. Identify appropriate tuning goals.
. Identify key information recorded by the alert log.
. Identify the parameters that control the location and format of the alert log file.
. Identify the different methods available for generating user process trace files.
. Identify the functions of the DBA views used to provide data storage statistics.
. Match the dynamic performance views with the statistics they provide.
. Match the V$ views used to collect system-wide statistics with their functions.
. Identify the factors taken into consideration in selecting the physical structure for data.
. Match the index types with their benefits.
. Identify the key usage of index organized tables.
. Identify the features of the Database Resource Manager.
. Identify the guidelines used to administer resource consumer groups.
. Identify the processes implemented by resource plans and resource plan directives.
. Identify the measures that can be taken to tune memory performance.
. Identify the I/O tuning areas that can improve overall system performance.
. Identify the CPU tuning practices that can improve overall system performance.

Top

Managing Memory and Disk I/O

The second part of the course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.

Learn To

. Match the optimizer modes with their descriptions.
. Match the OPTIMIZER_MODE parameter values with their description.
. Identify the methods of creating stored outlines.
. Identify the three major areas of the Shared Pool.
. Identify the parameters used to tune the Shared Pool.
. Identify the goals for tuning the Library Cache.
. Identify the descriptions of redo entries.
. Match the statistics used to diagnose disk I/O contention with their descriptions.
. Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session.
. Identify the performance guidelines to reduce the activity on an overloaded disk.
. Identify the methods of striping.
. Identify the initialization parameter that indicates the size of read calls during full table scans.

Top

Optimizing Sorts and Minimizing Contention

The last part of this course covers the details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.

Learn To

. Match the component of database storage with its definition.
. Avoid dynamic allocation of extents by using the ALTER TABLE command.
. Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
. Sequence the steps in the sort process.
. Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
. Identify the tuning sort goals.
. Match the uses of rollback segments with their definitions.
. Select the characteristics of rollback segment activity.
. Identify the characteristics of rollback segment growth.
. Identify the locking mechanism characteristics.
. Select the statements that characterize DML and DDL locks.
. Identify the DML lock characteristics.
. Sequence the process steps of the Oracle shared server configuration.
. Identify the characteristics of the Oracle shared server.
. Query a dispatcher process to determine the process status using the V$DISPATCHER view.

Top

Delivery

Computer Based Training (CD-ROM) and Manual

Content

Interactive, skills-based with practical examples

Duration

Approx 24 hours

Qualifications

Exam #1Z0-033 Oracle9i Database: Performance Tuning

Click here to get a free information pack

Need to talk to somebody about the Courses? Then call us on 01492 623887

Distance learning/Self Study

All courses are designed to offer you the student the convenience of studying from the comfort of your own home or workplace, working at your own pace in the way that is most suited to your lifestyle and career commitments. Working at your own pace means that you are more likely to learn the subject in-depth as you are not under pressure to compete with other students who may be better or worse than, so you will never lag behind or be waiting for somebody to catch up.

Keimos Database Courses

Our courses use simulations extensively to provide opportunities for students to learn & practice skills-based content. This “learning by doing'” model is far more effective than the traditional true/false, multiple choice approach. Live application software is not needed.

Interactive content is used often in the courses to engage the learner's attention, to reinforce and exercise skills being taught, and to provide feedback on the learner's grasp of a skill or concept.

Top

Oracle Courses


Oracle8i OCDA

Oracle9i DBA OCA

Oracle9i DBA OCP

Oracle9i: SQl

Oracle9i: Fundamentals 1

Oracle9i: Fundamentals 2

Oracle9i: Performance Tuning

Oracle Database Courses
Site Designed by Keimos©1997-2008

Valid XHTML 1.0! Valid CSS! .

database operations manager

The work

A database operations manager is responsible for organising, operating and maintaining information in a database. Databases store information such as customer names and addresses, stock records or accounts. Many organisations use databases including:

Database managers have a range of responsibilities including: They are also responsible for making sure that users understand the need to comply with the Data Protection Act.

They work closely with systems analysts in making changes to the database. Overall systems design decisions are performed by systems analysts; detailed database design is performed by database operations managers.

An organisation’s information needs change, so knowledge of the latest technology to recommend improvements to the system is important. Database operations managers work closely with information technology (IT) managers on a day-to-day basis.

Skills and Interests

As a database operations manager, you should:

Entry

There is no single route to becoming a database operations manager - the main requirements are having the right knowledge, skills and experience for the job. Qualifications are an important part of demonstrating these, and although a degree is often required, there are many other recognised academic and vocational qualifications.

Whilst the larger graduate recruiters may take trainees from any discipline, smaller employers generally require knowledge in specific computer languages, software packages or operating systems. Many employers will require a good honours degree. For others, experience in programming will help.

Many database operations managers move into this work from the business side of an organisation. However, they must have some experience in systems programming or systems design, and they often have a degree or higher national award, which can be in any subject. Experience can be just as important as qualifications for many jobs.

Training

The majority of training is on the job, supplemented by short internal or external courses as appropriate, and progress will be helped by taking additional manufacturers courses. Some IT companies offer specific certifications in their products.

Graduate Apprenticeships in IT may be available for people in England. These integrate study at degree or diploma level with structured work-based learning.

Many young people enter IT work directly through Modern Apprenticeships at Foundation and Advanced level, or Skillseekers and Modern Apprenticeships in Scotland. There are no set entry requirements but employers will want to be sure that applicants are motivated, enthusiastic and can benefit from the training.

Opportunities

Opportunities can arise within any organisation that makes use of computerised databases.

Specialist information technology bureaux, which provide a database service to clients, also employ database operations managers.

Managers can progress in their career by moving to another employer for a post with greater responsibility. Alternatively, they might transfer their skills to other areas of computing work, such as systems analysis, network management or general management.

Self-employment or freelance work is sometimes possible, and there are an increasing number of experienced database operations managers who do contract work.

Databases

Oracle8i/9i (DBA)

Curriculum is designed to give the Oracle Database Administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle8i database. Participants will learn about the concepts of relational databases and the SQL and PL/SQL programming languages, database administration strategies and procedures provided in Oracle8i, the critical skills for planning and implementing database backup and recovery strategies.

MCDBA

The Microsoft Certified Database Administrator is specifically for professional who implement and administer Microsoft SQL Server databases. Individuals who derive database designs, manage and maintain databases, configure and manage security and install and configure Microsoft SQL Server would benefit from this course.