I compared the topics of 1Z0-064 with 1Z0-054. Not surprisingly, the two lists are closely related, with the 12c exam being largely a refinement of the 11g incarnation. Some of the difference between the two exams include:
- Implement Real-Time Database Operation Monitoring
- Understand and configure the Database Resource Manager
- Identify performance issues & set tuning priorities
- Interpret tuning diagnostics
- Tune for life cycle phase
- Using Statspack
- Use Enterprise Manager Monitoring
- Identify the key tuning components of the alert logs
I find it interesting that Statspack was removed. Obviously AWR is Oracle's preferred performance tuning solution. However, unless that stops being a separately licensed option, a significant number of Oracle DBAs will continue to use Statspack for diagnosing performance problems. Ignoring this popular tuning option comes across as petty to me.
The 12c exam has considerably fewer topics than the 11g version (32 vs 54). Much of this comes in the form of topic consolidation. In several instances there are subjects that were split into several separate topics in 1Z0-054 that have been rolled into a single topic in 1Z0-064. Some examples include:
- Configure and manage services
- Use services with client applications, Database Resource Manager and Scheduler
- Configure services aggregation, tracing, and set performance-metric thresholds
- Configure and use services to monitor database performance
- Describe the buffer cache architecture
- Explain the symptoms that indicate a buffer cache problem
- Tune the buffer cache for performance issues
- Diagnose and resolve performance issues related to the buffer cache
I consider it unlikely that the information being tested on these consolidations has changed significantly. Most likely the questions have all simply been consolidated into a large bucket.
Performance is always a major factor for enterprise databases. No organization ever objects to their applications running faster or data being available more rapidly. This certification provides one more way for Oracle Database administrators to expand on their skill set.