Oracle Database 10g: New Resource, Scheduling, and Task-Management Features Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
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 (hours)
3.2
Lesson 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.
Course Number: 210074_eng