Click Here to Get Your All Access Project Management Pass!
  • This course has been retired. Users who have purchased the course will still have access to it, however it is no longer available for purchase.

Oracle 10g/11g Database Administration I Part 2

Course Features

  • Online Classes
  • Flexible Schedule
  • Interactive
  • High Quality
  • Certifications
  • Instructor Help

Online video courses with full instructor support,
just like in the classroom, only better. Enroll today!

Video Title
Length
00: Course Introduction
7 min
01: Oracle Shared Server
8 min
02: Configuration, Tuning and Monitoring
18 min
03: Database Performance Monitoring, Part 1
25 min
04: Database Performance Monitoring, Part 2
12 min
05: Database Maintenance Techniques
16 min
06: Using Advisors
18 min
07: Using the Automatic Database Diagnostic Monitor (ADDM)
22 min
08: Using the Workload Repository
11 min
09: Configuring Database Undo Management
14 min
10: Administering Database Undo Management
23 min
11: Detecting Database Locking Conflicts
7 min
12: Resolving Database Locking Conflicts
7 min
13: Database Backup and Recovery Concepts
13 min
14: Data and Log Files
12 min
15: Writer and Archiver Processes
24 min
16: NOARCHIVELOG and ARCHIVELOG Mode
7 min
17: Constituent Elements
10 min
18: Database Backups
20 min
19: User-Managed Backups and Individual Tablespaces
24 min
20: Server-Managed Backups
12 min
21: Types of Database Recovery
26 min
22: Using Flashback
15 min
23: Incarnations and Log Sequence Numbers
12 min
Total:
6 hrs 3 mins
Need Help Playing Your Videos or Quiz Modules? Click Here.

What should I do if my video will not play?

There are many things that can affect the quality of your video so we have put together these instructions to help you review all the things that need to be tested in order to trouble-shoot video quality.

The first thing we want to assure you is that we have done everything possible to make sure that our videos will play well.  Our videos are hosted in the cloud by Akamai.  Akamai has servers around the world to make sure that your videos are sent from the server that is closest to you.  By hosting our videos with Akamai we make sure that you receive the highest video quality. If you are experiencing video buffering or freezing at home or at the office there are a number of things you can do to help us troubleshoot.

  • Proper Video Quality: Although the player will attempt to match the video quality with your bandwidth, you may find that setting your video quality manually will give you better performance.
  • Popup Blockers: Please check to make sure that your pop-up blocker is turned off when you go to our website. This will prevent the video window from opening.
  • Your Connection Speed: Internet speed needs to be 2.0 Mbps upload and download to successfully watch the videos.  You will want to check and see if your connection speed is 2.0 Mbps or higher.  You can do this by clicking on this link and running a speed test.
  • Jitter and Packet Loss: Your Jitter rate lets us know if your connection speed is consistent while your Packet Loss rate lets us know if your internet connection could be losing pieces of the video.
    • Go to https://www.dotcom-tools.com/ping-test.aspx to determine if there is any Jitter or Packet Loss on your connection.
    • This is measured by a letter scale with A being the best.
      • If your Packet Loss is below a B, your connection is losing pieces of the video and causing the video to skip.
      • If your Jitter is below a B, your connection speed is very inconsistent and may be changing while you are watching the video which will result in buffering issues.
      • If either of these is the case you will need to contact your internet provider.
  • Shared Internet Connection: If you are on a shared internet connection, test playing videos during non-peak hours when usage by others on your network is low.
  • Reset Your Browser: If you've tried all the previous steps, your browser may be retaining data that needs to be deleted, and this requires a reset. If you are using Chrome, use the instructions in this link to reset your browser. If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset. If you are using Firefox, use the instructions in this link to reset your browser.
  • Other things to check:
    • At home or at work, test using different browsers and computers to see if you get the same result.
      • Make sure you have the latest version of the browser you are using.
    • If you are using Internet Explorer (IE) you may need to reset it. You can do this by clicking on the cog icon on the top right of your page. Then click on tools, internet options, advanced and reset.
    • Try from a different location using a different network.
    • If you are on a wireless connection try a wired solution.
    • If you are on a home network:
      • Test playing the videos when you are the only user on the network.
      • Try by-passing your router to eliminate it as the point of failure. A direct plug from your ISP to your computer will take care of this and will make sure that neither your router nor other users are affecting your connection.
    • If you are running Firefox, you can check your plugins here: https://www.mozilla.org/en-US/plugincheck/
  • Make sure you do not have any other programs open. File sharing and peer to peer sharing programs, even when limited to low bandwidth, can make it almost impossible to stream properly.
  • Tracking Progress on Mobile Devices: The GogoTraining site is designed to use the native player found in your browser. If you are taking your course on a mobile device and want to make sure your progress is tracked, then you will need to play the videos from the native player that is in your browser. Do not download any third party apps to play the videos as they do not allow your progress to be recorded. If you have installed a third party app and want to receive a Letter of Course Attendance, then you will need to uninstall the 3rd party app or see if the app has the ability for you to disable it for certain sites.
  • Submitting Debugging Information If you have tried everything else and still are having trouble viewing the videos, you can visit this page where you can help us debug your particular setup by following the instructions on the page and submit the debugging information to us.
Meet Your Instructor

Steve Hamilton

Steve Hamilton, a consultant and database administrator, has over 20 years of practical experience with Oracle, Sybase and SQL Server. He is certified in Oracle version 8 through 11g and is a charter member of the Nebraska Oracle User Group. He also holds a MCITP SQL Server DBA/Developer certification, Linux certification and a Real Application Clusters (RAC) certification. Steve has consulted for many fortune 500 companies including ConAgra, FDR, Sitel and TDAmeritrade. Since 1995 he has taught nationally in cities such as Atlanta, Los Angeles, Chicago, Denver and New York. Through his experience using these products in both small and large organizations, Steve delights students by bringing 'real world' examples to the classroom. He enjoys preparing students so they can immediately be productive when they return to their work environment. He received a bachelor of science degree in business administration with a specialization in management information systems from the University of Nebraska at Omaha.

Setting up Your Computer

System Requirements

Hardware:
•    Java Runtime Environment (JRE)
•    Memory requires 32 MB
•    200 MB disk space

Software:
•    Oracle Universal Installer 11g Release 2 (11.2)-Detailed set up will be provided with the course.

Course Links

Course Links

These links are activated when you purchase this course.

  • Course Survey
Course Transcript

Transcript

This course comes with a Transcript that tracks your progress. You can use your transcript to view and monitor your progress and when you complete the course, you can print or email the transcript.

Certificate of Completion

Certificate of Completion

You will be awarded a Letter of Course Attendance when you finish this course. You will be able to print or email the Letter of Attendance and share your accomplishment with everyone.

How to Take Your Exam

How to Take Your Exam

Oracle 10g/11g Database Administration I Part 2 online training is part of a two-course series that helps you to prepare for Oracle's exam 1Z0-052. This course maps to Oracle's course, Oracle Database 11g: Administration I.  When you pass exam 1Z0-052, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.

Course Description

In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Once you have completed Oracle 10g/11g Database Administration I Part 2 the next course you will want to take is Oracle 10g/11g Database Administration II Part 1. The Oracle 10g/11g Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 10g/11g Database Administration II Part 1 and Part 2.

In This Course You Will Learn:


•    Explain Oracle's architectural components.
•    Demonstrate how to use Oracle's universal installer and configuration assistants.
•    Identify the different interfaces to an Oracle database.
•    Describe the different database control and storage structures.
•    Explain how to use schema and user management tools.
•    Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database.
•    Describe PL/SQL declarations, code and exceptions.
•    Discuss Oracle's password security and database auditing features.
•    Configure Oracle's default user account features.
•    Configure and tune Oracle's Listener and Net Services features.
•    Learn how to establish, tune and monitor Oracle's Shared Server configuration.
•    Explain how to manually and automatically monitor the performance of an Oracle database.
•    Describe how to use Oracle's advisors to help tune and monitor database performance.
•    Show how to tune and administer Oracle's database undo management.
•    Discover how Oracle detects and resolves locking conflicts.
•    Learn the roles of control files, data files and redo log files in database backup and recovery.
•    Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery.
•    Discuss the different types of database backups.
•    Differentiate the differences between user-managed and server-managed backups.
•    Contrast the differences between database restoration and database recovery.
•    Illustrate the importance of database incarnations in database recovery.

Prerequisites

You need to have equivalent Oracle 9i database experience and have taken Oracle 10g/11g Database Administration I Part 1 or have taken the following GogoTraining courses:
•    Oracle 10g/11g: Introduction to SQL
•    Oracle 10g/11g: Advanced SQL
•    Oracle 11g PL/SQL Programming Part 1
•    Oracle 11g PL/SQL Programming Part 2
•    Oracle 10g/11g Database Administration I Part 1

Outline

Module 00: Oracle 10g/11g Database Administration I Part 2 Online Training - Course Introduction

Module 01: Oracle Shared Server
•    Architecture
•    Benefits and Features

Module 02: Configuration, Tuning and Monitoring
•    Oracle Shared Server Configuration
•    Tuning the Oracle Shared Server
•    Demo: Tuning the Oracle Shared Server
•    Exercise: Tuning MAX_SHARED_SERVERS
•    Monitoring the Oracle Shared Server
•    Exercise: Tuning Shared Servers

Module 03: Database Performance Monitoring, Part 1
•    Database Statistics: Manual vs. Automatic
•    Demo: Viewing Database Statistics
•    Exercise: Database Statistics
•    Exercise: V$OSSTAT View
•    Analyzing Objects

Module 04: Database Performance Monitoring, Part 2
•    Validating Database Structure
•    Demo: Validating Database Structure
•    Exercise: Validating Structure
•    Validating System Objects

Module 05: Database Maintenance Techniques
•    Alerts
•    Exercise: Alerts
•    Enterprise Manager
•    Threshold Information
•    Demo: Recovering from Non-Critical Losses
•    Exercises: Threshold Alerts and Views

Module 06: Using Advisors
•    SQL Access Advisor Package
•    Diagnostic Advisor
•    SQL Advisor
•    Tuning Advisor
•    Demo: Diagnostic and SQL Tuning Advisors
•    Exercise: SQL Tuning Advisor

Module 07: Using the Automatic Database Diagnostic Monitor (ADDM)
•    ADDM and AWR
•    ADDM Features
•    Reports
•    Demo: Automatic Database Management
•    Exercise: Working with ADDM

Module 08: Using the Workload Repository
•    Components
•    Snapshots
•    Views
•    Reports
•    Demo: Recovering from User Errors
•    Exercise: Generating an AWR report

Module 09: Configuring Database Undo Management
•    Definition of Database Undo Management
•    Exercises: Monitoring Database Undo
•    Configuration of Database Undo Management
•    Demo: Using Recovery Manager
•    Exercises: UNDO_RETENTION
•    Exercise: Undo Retention and Tablespace

Module 10: Administering Database Undo Management
•    Flashback
•    Flashback Mechanism
•    Flashback Query
•    Demo: Table Flashback
•    Exercise: Using Table Flashback
•    Undo Advisor

Module 11: Detecting Database Locking Conflicts
•    Detecting Database Locking Conflicts
•    Database Locking Modes

Module 12: Resolving Database Locking Conflicts
•    Detecting Deadlocks
•    Designing Avoidance of Deadlocks
•    Manual Locking

Module 13: Database Backup and Recovery Concepts
•    Overview
•    Control Files
•    Sizing Control Files

Module 14:  Data and Log Files
•    Data Files
•    Exercise: Viewing Absolute File Numbers
•    DB_ Files
•    Log Files
•    Listing Data Files
•    Exercises: Listing and Viewing Files

Module 15: Writer and Archiver Processes
•    Log Writer Processes
•    Archiver Processes
•    Demo: Performing Critical Database Recoveries
•    Exercise: Adjusting Archiver Processes

Module 16: NOARCHIVELOG and ARCHIVELOG Mode
•    NOARCHIVELOG mode
•    ARCHIVELOG mode
•    Implications of ARCHIVELOG mode and Automatic Archival

Module 17: Constituent Elements
•    Overview
•    Data Files
•    Redo Logs
•    Control Files

Module 18: Database Backups
•    Consistent Backups vs. Inconsistent Backups
•    Full Backups vs. Incremental Backups
•    Demo: Performing Backups

Module 19: User-Managed Backups and Individual Tablespaces
•    Performing User-Managed Backups
•    Configuring a Flash Recovery Area
•    Demo: Configuring a Flash Recovery Area
•    Exercises: Flash Recovery Area
•    Backing Up Individual Tablespaces
•    Demo: Backing Up Individual Tablespaces
•    Exercise: Backing Up Individual Tablespaces

Module 20: Server-Managed Backups
•    Performing Server-Managed Backups (RMAN)
•    Demo: Configure RMAN for Complete Backup
•    Exercise: Configure RMAN for Complete Backup

Module 21: Types of Database Recovery
•    General Categories of Recovery
•    Datafile Recovery
•    Demo: Restoring a Data File by its File Number
•    Exercise: Restoring a Datafile by Filenumber
•    Using RMAN for Recovery
•    Fast Database Recovery
•    Using Flashback
•    Demo: Flashback Database
•    Exercise: Fast Database Recovery

Module 22:  Using Flashback
•    Methodology
•    Flashback Drop
•    Recovering Objects from Recycle Bin
•    Demo: Recovering Objects from Recycle Bin
•    Exercise: Flashback Table

Module 23: Incarnations and Log Sequence Numbers
•    Incarnations
•    Log Sequence Numbers
•    Exercise: Log Sequence Numbers

Certification

Oracle 10g/11g Database Administration I Part 2 online training is part of a two-course series that helps you to prepare for Oracle's exam 1Z0-052. This course maps to Oracle's course, Oracle Database 11g: Administration I.  When you pass exam 1Z0-052, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.

GogoTraining, GogoTraining Designs, and miscellaneous designs are the trademarks of GogoTraining, Inc.

The ITIL® courses on this site are offered by GogoTraining, an ATO of AXELOS Limited

ITIL® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.

The Swirl logo® is a registered trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.

OBASHI® is a registered trademark of OBASHI Ltd. All rights reserved.

COBIT® is a trademark of ISACA® registered in the United States and other countries.

The International Organization for Standardization (ISO) is a non-governmental organization which is a network of the national standards institutes of 156 countries.

ISO is the owner of the ISO/IEC 20000 standard.

BRMP® is a Registered Trade Mark of Business Relationship Management Institute, Inc.

SIAM® is a registered trademark

VeriSM™ is a trade mark of IFDC

PMI®, PMP®, CAPM®, and PMBOK® are registered marks of the Project Management Institute, Inc.

AgilePM® is a registered trademark of Agile Business Consortium Limited. All rights reserved

All other trademarks on this site are the trademarks of their respective owners.

GogoTraining - Leader in IT & Management Training

©2009-2024 GogoTraining, Inc. All rights reserved.

Sign up

  • All GogoTraining Members receive the first 3 course modules for free so they can meet the instructor, understand what they will learn by taking the course and review the content. Sign Up today and get access to the best trainers and online self-paced video training content in the world.