Oracle Database 10g: Administration Workshop II

Oracle Database 10g: Administration Workshop II Course Description

Intended Audience for the Oracle Database 10g: Administration Workshop II Course

• Sales Consultants
• Database Administrators
• Support Engineer
• Technical Consultant

Oracle Database 10g: Administration Workshop II Course Objectives

• Use RMAN to create and manage backup sets and image copies
• Recover the database to a previous point in time
• Use Oracle's Flashback technology to recover your database
• Detect block corruptions and take appropriate measures to correct them
• Use the various Database advisors and views to monitor and improve database performance
• Control database resource usage with the Resource Manager
• Simplify management tasks by using the Scheduler
• Improve the security of the listener
• Review database log files for diagnostic purposes
• Customize language-dependent behavior for the database and individual sessions

Required Prerequisites for the Oracle Database 10g: Administration Workshop II course

• Oracle Database 10g: Administration Workshop I

The Oracle Database 10g: Administration Workshop II Course prepare students for the following Exams

• 1Z0-043 : Oracle10g Database: Administration II

Oracle Database 10g: Administration Workshop II Course Outline

1. Using Globalization Support
   1. Datetimes with Timezones
   2. Specifying Language-Dependent Behavior
   3. Locale Variants
   4. Linguistic Sorting
   5. Case and Accent Insensitive Sorts
   6. Linguistic Comparisons
   7. Obtaining Information about the Current NLS Configuration
2. Securing the Oracle Listener
   1. Listener Password Authentication
   2. Controlling Database Access
   3. Securing the EXTPROC Service Entry
3. Configuring Recovery Manager
   1. Using a Flash Recovery Area with RMAN
   2. Setting Parameters for RMAN
   3. Starting RMAN
   4. Configuring Persistent Settings for RMAN
   5. Control File Autobackups
   6. Retention Policies
4. Using Recovery Manager
   1. Issuing Recovery Manager Commands
   2. Parallelization of Backup Sets
   3. Compressed Backups
   4. Copying the Whole Database
   5. Making Incremental Backups
   6. Block Change Tracking
   7. Incrementally Updating Backups
   8. Monitoring RMAN Backups
5. Diagnostic Sources
   1. The Alert Log
   2. Viewing Alerts with EM
   3. Alerts Notification
   4. Editing Thresholds
   5. Trace Files
6. Recovering from non-critical losses
   1. Creating New Temporary Tablespace
   2. Recreating Redo Log Files
   3. Recovering an Index Tablespace
   4. Read-Only Tablespace Recovery
   5. Loss of Password Authentication File
7. Database Recovery
   1. Recovery Steps
   2. User-Managed Recovery Procedures: RECOVER Command
   3. Types of incomplete recovery
   4. Incomplete Recovery Best Practices
   5. Recovery Using EM
   6. Simple Recovery Through RESETLOGS
   7. Point-in-time recovery using RMAN
8. Flashback database
   1. When to Use Flashback Technology
   2. Configuring Flashback Database
   3. Monitoring Flashback Database
   4. Best Practices for the Database and Flash Recovery Area
   5. Flash Recovery Area Space Usage
   6. Flashback Database Examples
9. Recovering from User Errors
   1. Recycle Bin
   2. Flashback Dropped Tables Using EM
   3. Querying Dropped Tables
   4. Flashback Versions Query
   5. Flashback Transaction Query
   6. Using Flashback Versions Query and Flashback Transaction Query
   7. Flashback Table
   8. Using EM To Flashback Tables
10. Dealing with Database Corruption
    1. What is block corruption?
    2. Interpreting DBVERIFY
    3. The ANALYZE command
    4. How to Handle Corruptions
    5. The DBMS_REPAIR Package
    6. Block Media Recovery (BMR)
    7. Detecting Database Corruptions Using DBVERIFY
    8. Using RMAN to Repair Corrupt Blocks
11. Automatic Database Management
    1. Automatic Optimizer Statistics Collection
    2. Workload Repository
    3. Database Control and Advisors
    4. Using the SQL Tuning Advisor
    5. Using the SQL Access Advisor
    6. Automatic Undo Retention Tuning
12. Monitoring and Managing Storage
    1. Redo Logfile Size Advisor
    2. Resumable Statements
    3. Tablespace Space Usage Monitoring
    4. Accessing the Segment Advisor
    5. Shrinking Segments Using SQL
    6. Segment Resource Estimation
    7. Monitoring Index Space
    8. Identifying Unused Indexes
13. Automatic Storage Management
    1. ASM Concepts
    2. ASM General Architecture
    3. Creating an ASM instance
    4. Creating tablespaces that use ASM storage
    5. Viewing ASM information
    6. Migrating a tablespace to use ASM storage
14. Monitoring and Managing Memory
    1. Oracle Memory Structures
    2. Automatic PGA Memory Management
    3. Using the Memory Advisor
    4. Using Automatic Shared Memory Management to avoid long running query issues
15. Managing Resources
    1. Creating a New Resource Plan
    2. Creating Resource Consumer Groups
    3. Assigning Users to Resource Consumer Groups
    4. Adaptive Consumer Group Mapping
    5. Using Sub-Plans to limit CPU Utilization
    6. Administering the Resource Manager
    7. Resource Plan Directives
16. Automating Tasks with the Scheduler
    1. Creating a Scheduler Job
    2. Using Scheduler Programs
    3. Creating and Using Schedules
    4. Creating a Job Class
    5. Prioritizing Jobs within a Window
    6. Viewing Job Execution Details
    7. Creating a job that runs a program outside of the database

Benefits of taking the Oracle Database 10g: Administration Workshop II course at NetCom

• Why choose Oracle Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Finnbarr M. - Masters Degree in Computer Science from Boston University along with several certifications. - Over 25 years of experience in the IT field and expert in Unix, GNU/Linux, and Oracle ecosystems. - More than 10 years working as a Software Engineer in multinational companies such as Hewlett-Packard. Bio: Finnbarr has both breadth and in-depth knowledge of Unix, GNU/Linux, and Oracle with 25+ years of experience in operating system internals development, system administration, application development and project management on a wide variety of hardware and software platforms. As a Software Engineer, he developed and managed numerous projects in multinational companies such as Hewlett-Packard. Finnbarr is a member of the Institute of Electrical and Electronic Engineers as well as a Moderator at unix.com. He is also a top Instructor and Subject Matter Expert at NetCom Learning and is well recognized by the students for his knowledge and his great teaching technique.

  See more...  
• Actual Client Testimonials

  Aug 29 2011 My instructor is very knowledgeable. He was capable of answering all questions and explaining all material in detail. I am glad I chose NetCm for my training. All of the NetCm staff were courteous helpful, and polite. -Adrienne B. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 I am very pleased about my experience with NetCom Learning. It was a great course! The best experience I could have expected. Great instructor! Great everything! I am very happy. Thank You! -Lorena M. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 Very clean facilities, super friendly staff, knowledgeable instructor. -Alma C. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Jul 02 2011 Geoff was a great instructor during the Oracle course. He ensured I understood the material and brought a sense of fun to the class. I really really have to study for the certification course due to my limited database management skills. This training and certification will hopefully allow me to start a new career. -Denise L. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Mar 07 2011 [The Instructor] has knowledge, experience, approach and commitment. Further these classes are more important even for the experienced people. The arrangements and food are good . -Sai P. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Mar 05 2011 Although it was a lot of information it was a good experience. Very informative and very good. -Melvin H. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Mar 05 2011 NetCom has done a great service. The arrangements are good. The food is good. Geoff has done a very good job. His dedication to his profession is highly notable and appreciated. This class really refreshes the fundamentals. -Sai P. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  

  Mar 05 2011 Geoff is one of the best instructors I've taken a course from. Very knowledgeable and I would take a course from him anytime. -Kyle A. Course(s) Taken Oracle DBA Track (11g) - Boot Camp

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Bootcamp Training
  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the Oracle Database 10g: Administration Workshop II course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com