Materialized views are, along with indexes, the most important thing in a DB to improve performance of complex joins in tables that are not updated so frequently. Having a good knowledge of it is very important, so, finish this topic only when you understand very well it's usage. Most important thing here, as the topic says …
Jun 12
OCM 11g Preparation - Perform various recovery operations using Flashback technology
This topic is big. Oracle has a lot of flashback technologies and the world "various" here means "all". We have flashback table / transaction / database, and each of those has a lot of features. If your brain is not capable of memorizing all those syntax, do like me: understand very well the concepts, practice all …
Jun 12
OCM 11g Preparation - Configure a Fast Recovery Area
Fast Recovery Area (the old Flash Recovery Area) is where you keep by default your local backups, archives, flashback logs, restore points, one redo member and so on. Configuring it is pretty simple. All you need is to understand and set up the following parameters: db_recovery_area_dest db_recovery_area_dest_size Path to Documentation: Backup and Recovery User's Guide -> 5 …
Jun 11
OCM 11g Preparation - Set Flashback Database parameters
For this topic, we are focusing in flashback database technology. So here, you need to be able how to: Enable / Disable flashback database; Enable / Disable flashback for a tablespace; Alter all the flashback database parameter "db_flashback_retention_target"; One thing that I would strong recommend during the exam is: every time you plan to do some …
Jun 10
OCM 11g Preparation - Create different types of RMAN backups to cater for different performance and retention requirements
Backup is an art. It's very important to check the SLA and create a total failure recover plan whenever you setup a new DB instance. If you are a OCP, you must already know that. So, in this topic, practice creating backups: Backup full / incremental If Incremental, diferential / cumulative Compressed in different levels Setup …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
