Database Replay is a feature in EM12c that a lot of folks are unfamiliar with, but once they learn about it, well, now then they figure out how valuable it really is. Where the ADDM Comparison Report comes in really handy when you want to see what changed, think about how much more value there is if you could test out what a change in parameters, patches, or in code would do to a (more...)
Active Session History, (ASH) reports are one of my favorite when investigating a performance issue. The biggest challenge I think that faces many administrators is to know when to turn to an ASH report and how to use the report to diagnose an issue.
Today’s example is brought to us thanks to a Workload replay that should be a simple, but also, a clear step by step of when and why to use an ASH (more...)
I’ve had a recent request to write an update on working with AWR reports, so as promised, here it is!
The Automatic Workload Repository
The Automatic Workload Repository, (AWR) was one of the best enhancements to Oracle back in release 10g. There was quite a goal put in front of the development group when they were asked to develop a product that:
1. Provided significant performance recommendation and wait event data enhancements over its predecessor (more...)
The term “Service” is used to represent numerous objects within Enterprise Manager 12c. Although the most common reference to the term is related to the Oracle Management Service, (OMS), in this blog post, we are going to drill down and refer to all services identified in the drop down menu from Targets, Management Services and Repository.
The two main services we are going to cover here are set up as part of the Oracle Enterprise Manager 12.1.0. (more...)
January is winding down and RMOUG Training Days 2015 is just around the corner, taking up much of my after work hours.
With that, we are going to discuss a great performance console in the EM12c cloud control- Cluster Cache Coherency.
Cluster Cache Coherency
Optimization for an Oracle Real Application Cluster, (RAC) can be a daunting tasks for those that aren’t familiar with some of the most common issues to look for. Although many (more...)
I’ve had a few folks ask me a similar question about the AWR Warehouse, occuring numerous times this week.
“How can I limit what the user of the AWR Warehouse can view in the AWR Warehouse?”
“How can I add source databases to the AWR Warehouse without DBA privileges?”
This topic bridges into the area of confusion of use of the EM12c environment, (which I consistently promote for use by DBAs, Developers (more...)
Every job comes with tasks that no one likes to perform and database administration is no exception. Patching is one of those necessary tasks that must be performed and when we are expected to do more with less everyday, the demands of patching another host, another agent, another application is often a task that no one looks forward to. It’s not that it goes wrong, but that it’s just tedious and many DBAs (more...)
As many bloggers and sites do this time of the year, here is my review of 2014. It was a great year and it was a lot of fun, as well as educational reviewing all the data.
Busiest Day on my Blog:
Posts this year:
Most popular post of 2014: Easy EM12c Agent Deployment on Windows
Windows installations are still a huge mystery and Cygwin still frustrates a lot of people, sometimes, me (more...)
I chose to work for Oracle because I wanted to immerse myself in the Oracle Enterprise Manager product. It was the right place for me. It didn’t matter that I had a background as a multi-platform DBA or that I my skill set was deeply involved in optimization of complex, large databases. I knew it was right for me and I trust my instincts. Due to research and the opportunities preesented (more...)
Today we’re going to review another great feature in the EM12c that you may not have realized was available. Once logged into a database target, click on the Performance menu and navigate to the Optimizer Statistics Console:
Optimizer Statistics Console Page
The new console page is clean, easy to navigate and has great access points to manage and monitor optimizer statistics for the given database target.
We’ll actually start at the bottom of the (more...)