Jun 01

OCM 11g Preparation - Create programs

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

May 27

OCM 11g Preparation - Create schedules

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

May 26

OCM 11g Preparation - Create Scheduler jobs

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

May 26

OCM 11g Preparation - Choose the appropriate tablespace type for the intended use

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

May 25

OCM 11g Preparation - Implement Grid Control and Database Control

Grid Control and Database Control can and must run in the same time in your simulation environment. Why? Because they may be used in different times during the exam, and EM can help you a lot saving time! If you only know how to configure the Grid Control and you are asked to do that …

Continue reading