Star transformation can be really useful in DW environments, where you have your tables divide into dimensions and facts. And the most important, you need to have bitmap indexes! To implement it, you need to change the star_transformation_enabled for your user session and create the tables and indexes to play. Try to practice creating one fact …
Jun 17
OCM 11g Preparation – Manage Transport of tablespaces across platforms
Transporting whole tablespaces is a very good and practical way to move data from one Database to another. Oracle will generate a small dump with the object’s metadata and all you need to do is copy the datafiles and dumps to the new system. In this topic, practice: Check if Transport is possible with DBMS_TTS.TRANSPORT_SET_CHECK …
Jun 16
OCM 11g Preparation – Create and Manage encrypted tablespaces
This topic talks about “encrypted tablespaces“, not “encrypted data” or “encrypted columns“. So, while studying for OCM, I would recomend you to focus a bit more in tablespace encryption. Studying for “Oracle Database 11g Security Certified Implementation” is the best way to be very good in TDE implementation. Here you need to be very fast in: Point sqlnet.ora to …
Jun 15
OCM 11g Preparation – Configure and manage distributed materialized views
Word distributed is a little ambiguous here. So, what I recommend you to study is going deeped in anything of a mview that can be classified as distributed as: Partitioned Materialized Views Nested Materialized Views Materialized Views over DB Link Refresh Groups to sync MViews Path to Documentation: Oracle Database Data Warehousing Guide -> Basic/Advanced Materialized …
Jun 15
OCM 11g Preparation – Manage Materialized Views to improve rewrite and refresh performance
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 …
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
