Completed the Configuring Linux for the Installation of Oracle Database 10g lesson

Completed the Installing the Oracle Database 10g on Linux lesson

Completed the Scheduling Jobs lesson

Open a browser and enter the following URL:

http://<hostname>:5500/em

Login as sys/<password> as SYSDBA and click Login.

Click Administration tab.

Click Job Classes.

Click Create.

Enter the following information and click the search light next to Resource Consumer Group.

Name: COMPUTE_CLASS001
Description: This job class contains all the compute jobs
Logging Level: log job runs only (RUNS)
Log Retention Period: 7

Select the LOW_GROUP consumer group and click Select.

Click OK.

Your job class has been created. Click your Database breadcrumb.

9.

A user needs to have EXECUTE privilege on a job class to create jobs in that job class. Click Users.

10.

Select the user you want to have access to this job class. In this case, click HR.

11.

Select Object Privileges tab.

12.

Select Job Classes from the Select Object Type drop down list box and click Add.

13.

Click the Search light next to Select Job Classes.

14.

Check COMPUTE_CLASS001 and click Select.

15.

Select EXECUTE from the list of privileges and click Move. Then click OK.

16.

Click Apply.

17.

Now the HR user can create jobs that can belong to the job class.. Click the database breadcrumb.

Click Windows.

Click Create.

Enter the name COMPUTE_WINDOW001 and click Create Resource Plan.

Enter the Plan COMPUTE_PLAN001 and click Modify.

Select LOW_GROUP and click Move. Then click OK.

Enter 90 for the LOW_GROUP Level 1 plan and 10 for the OTHER_GROUPS Level 1 plan. Then click OK.

Enter the following information and click OK.

Resource Plan: COMPUTE_PLAN001
Priority: High
Description: For the duration of this window the COMPUTE_PLAN001 will be active
Schedule: Use a Calendar
Repeat: By Days
Interval: 7
Time: 11:00PM
Start: Later
Date:Today's date
Time:6:00PM
Duration: 4 hours
End Date: One year from today's date

8 .

Now you are ready to create a job that uses the window and job class you just created. Click your Database breadcrumb.

Click All Initialization Parameters.

Enter resource in the filter field and click Go.

Select TRUE for resource_limit and click Apply.

The change has been made. Click your Database breadcrumb.

Click Jobs.

Click Create.

Enter the following information and click the search light next to Job Class.

Name: CPU_JOB001
Owner: SYS
Enabled: No
Description: This job is a cpu intensive job
Logging Level: Log job runs only (RUNS)

Select the COMPUTE_CLASS001 Job Class and click Select.

Select TRUE for Restartable and enter the following in the Command Type area and select the Schedule tab.

declare
  i number;
  f number;
  begin
    for i in 1..30000000 loop
      f := f * i;
    end loop;
  end;

Make sure the Start is set to Immediately and click OK.

Your job has been created. Click the Disabled tab to see the job you just created. If you cannot see the job click Refresh..

Select the radio button in front of the job CPU_JOB001 you just created and click Create Like.

Change the following and click the search light next to Job Class.

Name: CPU_JOB002
Enabled: Yes

Select the DEFAULT_JOB_CLASS Job Class and click Select.

Click OK.

Select the job CPU_JOB001.

Change Enabled to Yes and click Apply.

Select the Jobs breadcrumb.

Select the Runing tab.

You notice how the cpu is allocated between the two jobs.

Click Purge All Logs.

Click Yes to confirm.

All the logs have been purged.