Category: OCM 11g Preparation

This topic is not so specific as the others. It says "Support optimal data performance". This lead us to think in about 1000 items that are relates to performance in a DB. Basically, this means: study a lot of performance. Read the whole Oracle doc for Performance Tuning and get the OCE Performance Tuning. This is …

Continue reading

Here you need to know how to strip the oracle data files. It is "data files", not "datafiles". So, don't forget to strip any kind of oracle file in different mount points, like: Controlfiles Redologs Tablespaces (create more than one datafile for each) You can also do a indirect striping using +ASM diskgroups across multiple …

Continue reading

Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace to use as a template. …

Continue reading

In this topic, you must be able to: Alter all the DB parameters that define any kind of memory or disk sizing. I would recommend you to run "show parameters size" and play with all of them. Create datafiles with different block sizes and check the usage of the db_NK_cache_size areas. Path to Documentation: Administrator's …

Continue reading

For OCM Preparation, in this topic you must be able to easily deploy an EM Grid Control agent. Although the term "deploy" let us think that we need to do it using the DB Console, I recommend also practicing the manual agent deployment. So, do the following scenarios: Install and deploy EM Agent in a new server …

Continue reading