Oracle Database 10g: New Resource, Scheduling, and Task-Management Features

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

Overview

To identify the new resource, scheduling, and task-management features of Oracle 10g

Target Audience

Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites

Experience in the administration of Oracle 8i or 9i databases

Expected Duration

190 min.

Course Objectives

Oracle Database 10g: New Resource, Scheduling, and Task-Management Features

  • use the new resource-plan timeout and session mapping features of Resource Manager in Oracle Database 10g.
  • use the new group switching and CPU allocation features of Resource Manager in Oracle Database 10g.
  • set idle time outs for a consumer group and create a mapping between a consumer group and a session attribute in Oracle Database 10g.
  • define the components of the Oracle Database 10g Scheduler and identify the SQL used to assign privileges to them.
  • create jobs, programs, and schedules in Oracle Database 10g.
  • create job classes, windows, and job priorities in Oracle Database 10g.
  • create a job class, job, and window in Oracle 10g Enterprise Manager in a given scenario.
  • use the GUI and code-based tools to manage Scheduler components in Oracle Database 10g.
  • use the tools to manage Scheduler component attributes and global attributes in Oracle Database 10g.
  • view information about jobs and purge jobs in Oracle Database 10g.
  • manage and view Scheduler components in Oracle Database 10g in a given scenario.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?