Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance

This course is included in our On-demand training solution.

Overview

recognize the steps required to manage undo information, secure an Oracle Database 11g database, and maintain it by monitoring statistics, automated tasks and alert thresholds.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites

A working knowledge of SQL

Expected Duration

145 min.

Course Objectives

Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance

  • recognize the steps for managing undo operations in Oracle Database 11g to allow users to roll back transactions.
  • recognize the requirements and best practices for implementing database security according to international and regional laws.
  • recognize the steps for enabling, specifying, maintaining, and reviewing database auditing.
  • recognize the process for obtaining and applying Critical Patch Updates (CPUs).
  • configure an Oracle Database 11g database to support retention and implement database security in a given scenario.
  • recognize the steps for managing and gathering optimizer statistics.
  • identify the steps for managing Automatic Workload Repository (AWR) statistics, using the Automatic Database Diagnostic Monitor (ADDM), and utilizing advisors.
  • identify the steps for viewing and configuring automated tasks and setting alert thresholds.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?