Category: OCM 11g Preparation

Job classes are also templates for jobs, but instead of defining a standard "code" format, like PROGRAMS, with classes you pre-define the logs retention and capture standards, resource consumer and services. For this item, practice creating a job class via EM and assign a job to it. Like programs, it's less probable that this item will be requested …

Continue reading

Programs are like "templates" for job's code. With a program you can pre-define the procedure/executable and arguments for a job. So, if you change your body code or call (let's say you renamed or changed the location of the shell script that execute via JOB), all you need to do is to modify your PROGRAM instead of every job. …

Continue reading

Schedules are predefined dates/times/interval to run something. In this topic, you must know how to create one using EM or SQLPlus (less probable). Be ready to access the "Calendaring Syntax" in the official documentation if you need any extra custom setup that is not available in Grid Control interface. And also practice creating a job with …

Continue reading

So, "Create Scheduler jobs" is another topic related to database, not Grid Control. But it is not placed in another skillset. Why? I hope you remember that if asked to create a job with class, program, scheduler and so on. The manual approach via DBMS_SCHEDULER would probably take the whole exam time, but you must be able …

Continue reading

It's interesting to see this topic inside the "Enterprise Manager Grid Control" skillset. As the topic "Create and manage temporary, permanent, and undo tablespaces", you must know all the options while creating a tablespace, but the keyword here is "for intended use". What does that mean? That not always the classic LMT with ASSM is …

Continue reading