June 2015 archive

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading