Performance Management

I would like to share my learning experience of Oracle Database Performance Management. This article also covered skillset5 for OCM12c Certification Exam.

• Configure the Resource Manager
• Tune SQL statements
• Use real application testing
• Manage SQL Plan baselines
• Capture performance statistics
• Tune an instance
• Configure and manage result cache
• Manage extended statistics
• Create and manage partitioned indexes
• Control CPU use for Oracle Instances
• Configure and manage “In Memory” features

Go back to OCM 12c Preparation Project 

Thank you for visiting this blog 🙂

Data Management

I would like to share my learning experience of Oracle Data Management . This article also covered skillset4 for OCM12c Certification Exam.

• Manage additional buffer cache
• Optimize space usage for the LOB data
• Manage an encrypted tablespace
• Manage schema data
• Manage partitioned tables
• Set up Fine-Grained Auditing
• Configure the database to retrieve all previous versions of the table rows

Go back to OCM 12c Preparation Project 

Thank you for visiting this blog 🙂

Data Warehouse Management

I would like to share my learning experience of how to manage the Data Warehouse. This article also covered  skillset3 for OCM12c Certification Exam.

• Manage database links
• Manage a fast refreshable materialized view
• Create a plug-in tablespace by using the transportable tablespace feature
• Optimize star queries
• Configure parallel execution
• Apply a Patch
• Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
• Manage external tables

Go back to OCM 12c Preparation Project 

Thank you for visiting this blog 🙂

OCM 12c Preparation for General Database and Network Administration

General Database and Network Administration

• Create and manage pluggable databases
• Administer users, roles, and privileges
• Configure the network environment to allow connections to multiple databases
• Administer database configuration files
• Configure shared server
• Manage network file directories

Go back to OCM 12c Preparation Project 

Thank you for visiting this blog 🙂