So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience. I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to the ODTUG members on this feature that everyone is so anxious to get their hands on. Let’s start with some of the top questions: 1. Can I just load the AWR data into the OMR, (Enterprise Manager Repository) database? A. No, it is highly recommended that you do not do this- use a…
-
-
The webinar is over, but you haven’t missed out on everything I presented on the console feature, under the hood and behind the scenes! You can access the slides from today’s presentation, as I’ve uploaded them to slideshare and the scripts are easy to locate on the scripts page here on DBAKevlar. Thanks to everyone who attended and a big thanks to GP for doing the introduction and ODTUG for hosting us! 🙂
-
So, there is a lot to cover on this topic and I hope Part I got you ready for more! Part II, I’m going to cover the following areas of the AWR Warehouse: Installation Access ETL Load Process Installation Let’s start with Prerequisites: The AWR Warehouse Repository must be version 11.2.0.4 or higher. The Targets and I think this will get a few folks, need to be 12.1.0.2 or higher, (now folks know why some docs aren’t available yet!:)) Just as with installing ASH Analytics, etc., make sure your preferred credentials are set up for the database you plan to…
-
I know a number of us performance tuning DBAs who’ve long wanted to retain AWR data, at least high-level AWR data for an extended period outside of the AWR repository on the local database. I implemented my own solution back in 2009-2010 at a previous employer as I was tired of hearing, “nothing’s changed”. Nothing like having the high-level AWR data on CPU, IO, network, application and concurrency waits to rebuke this type of assumption at budget decision time…. 🙂 The AWR data is collected as snapshots from ASH, AWR and ADDM in the target databases and then loaded to…
-
If you have the Diagnostics/Tuning Management Packs and EM12c, you should be installing ASH Analytics to get the full benefit of optimization data that is available via the AWR and ASH. ASH Analytics is the future of the Top Activity view and I’ve written a number of posts on the value of the ASH Analytics product. With EM12c Release 4, there are a few, small improvements in the ASH Analytics installation. Where before, there were some challenges to verification of installation success, checking the status of a scheduled installation job, now it’s much easier. If the ASH Analytics package hasn’t…
-
When working with Top Activity, we’re accustomed to viewing to wait class in the top, graphed area and below left, the top SQL by SQL_ID and below right is our Top Session information. ASH Analytics was designed so you would enter into a view that looked very similar to Top Activity, but was enhanced so the user could update it to view the data in multiple ways. In Enterprise Manager’s traditional view of Top Activity, it is easy to recognize the similarities with ASH Analytics but that’s where much of it stops. The user has the ability to change not just the…
-
I’m often present to overhear comments like the following when issues arise: I *think* someone changed something. I bet some DBA changed a parameter! I know <insert name of person on the bad list> is running that process I told him/her not to! Making assumptions vs. having data is a good way to alienate peers, coworkers and customers. There is a great feature in the EM12c that I’ve recommended that can easily answer the “What changed?” questions and deter folks from making so many assumptions about who’s guilty without any data to support the conclusion. It’s called the ADDM Compare…
-
We’re going to continue onto Session Identifiers in the ASH Analytics Activity view. You can use the links to view Part I and Part II to catch up on the ASH Analytics fun! Knowing just how many ways you can break down ASH data is very helpful when you are chasing an issue and need specific data to resolve it. We’ve already taken a deeper look into SQL and Resource Consumption, so not onto the session identifiers. Session identifiers in ASH Analytics cover the following- A session identifier provides distinct information about the session or sessions. Like previous blog posts,…
-
This is the second post on ASH Analytics Detail. You can find the first post here. This post we’re going to work into more Activity data within ASH Analytics, but I’m focusing on Resource Consumption, which you can find once you are into Ash Analtyics, (you may want to stop refreshes, which can be done at the upper right in the refresh settings) under the Activity button. We’ll be working with the last three options in this menu marked off in red, as the Wait Class is just a similar view of what we already get in the main Activity…
-
I have a request to hit on some EM performance blog posts, so we’re going to start with breaking down some of the ASH Analytics areas. ASH Analytics is not your grandfather’s “Top Activity” and I recommend everyone begin to embrace it as it is the the future of performance activity in the Enterprise Manager. The idea that we will be able to pull directly from ASH and AWR to present our performance data via the EM12c is exciting, to say the least. The added accuracy and value of the aggregated historical data must be recognized as well. The standard…
-
I would like to thank James Murtagh, Redgate and everyone who attended the webinar today on ASH and AWR Performance Data. You can find my slides at the Redgate site and here. I have added links in a new section of my Scripts tab on this site with all the ASH queries, please let me know if you see any that appear to be missing, I uploaded these pretty quick before returning to assist a client this morning! 🙂 Thank you again to Redgate and to all those who joined us!
-
Rarely are reports based off large snapshot variances helpful to a DBA unless you come across an odd situation such as this one…Better yet, we need to know a little bit about our AWR tables behind our reports so we can piece together what the reports leave out…:) Scenario: After-hours support has killed a session after high temp usage has occurred. You, as the primary DBA, are left to look into the issue the next day. Your first attempt to inspect the issue is through Enterprise Manager, (OEM) and you are surprised that very little activity is actually showing up…
-
Yes, I love AWR and ASH reports when performing database detective work. They are an essential tool in my performance tuning arsenal, along with the logs, trace files/profiling, Oracle Enterprise Manager and a suite of personally collect queries from over the years. As complex as databases are these days, the more data that I have at hand to backup what I am tuning or reporting on, the more comfortable I am, (OK, so I’m not one for “theories”… :)) Just as I would not use a screw driver to hammer in a nail, all DBA’s should understand and not confuse…