Oracle Certified Master 11g Exam Guide: A Comprehensive Practical Study Guide

Oracle Certified Master 11g Exam Guide: A Comprehensive Practical Study Guide Description

Congratulations! on the successful completion of the Oracle DBA 11g Certified Master practicum. You are now a member of an elite group of Oracle professionals. Every Oracle DBA dreams to get this message from Oracle and one day become an Oracle Certified Master. But when it comes to the preparation, it seems to be hard as there s no book available in the market for OCM 11g exam. It took me 2 years to prepare this book. For every single topic of the exam I made a deep research of Oracle documentation, metalink notes, blog posts and books and prepared practical guidance that will help you to be prepared for the OCM tasks. This Study Guide contains the following information: In the beginning of each topic, a reference from Oracle documentation and metalink notes is provided to get more information on a specific subject. Each topic is explained in a practical examples using both graphic user and command line interfaces. At the end of each topic a reader is assigned to solve different pre-created tasks in a specified time limit. The book consists of 9 chapters and more than 200+ practical OCM scenarios. Server Configuration chapter provides a detailed step-by-step guide on Oracle 11g Database Software setup and new database creation through GUI and silent mode likewise. Enterprise Manager Grid Control chapter starts by illustrating a detailed step by step installation of OEM Grid Control starting from the download methods of all OEM components till successful installation. In this chapter you will also see how to create Programs, automate Jobs, create Schedulers, Alerts and Notifications. Managing Database Availability chapter provides steps to create and manage the recovery catalog. A number of ways also introduced to create a backup of a database and detailed step by step explanation of database recovery from different failure cases through RMAN is provided. Data Management chapter provides detailed information about types of materialized view and materialized view log and how Oracle uses precomputed materialized view instead of querying a table with different aggregate functions and provides a quick result. Data Warehouse Management chapter provides information about main data warehouse topics such as partitioning and managing large objects. Next, we talk about large objects and show how to use various SecureFile LOB features such as compression, deduplication, encryption, caching and logging. Performance Tuning chapter provides a detailed information on SQL Tuning tools such as SQL Tuning Advisor, SQL Access Advisor and SQL Performance Advisor. Beside the tuning tools, it provides information about resource manager, result cache, multi-column statistics and implementing instance caging. Grid Infrastructure and ASM chapter covers more than enough material to get you started with step by step installation of Oracle Grid Infrastructure. This chapter also sheds light on general Oracle ASM technology and provides information on how to create ASM diskgroups, how to configure failure groups and how to practice disk crashes in ASM environment. Next, we introduce ACFS file system and provide steps to create and manage it. Real Application Clusters chapter explores steps to successfully create a RAC database on two nodes. With only few additional steps, you will successfully create a RAC database. Then you see the way how to create and configure ASM with command line interface. Once ASM is configured, silent RAC database creation steps are provided. Data Guard chapter starts by creating a data guard using command line interface, OEM and data guard broker. It also provides steps on performing switchover and failover using all mentioned tools.