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…
-
I talk a lot about Enterprise Manager 12c, from the OMS all the way to the EM CLI and the Agent, but I was discussing some interesting history with the account used by the OEM Management Agent- the DBSNMP account. The origination of the DBSNMP account was to support Oracle SNMP, (Simple Network Management Protocol.) Back in Oracle 7-8i days, this account was vulnerable to all kinds of nasty issues and there were steps that administrators needed to take to secure it- from making the snmp_rw.ora file inaccessible except to the ORACLE OS user, (residing in the $ORACLE_HOME/rdbms/admin directory) to…
-
I’m still asked this question, as I’ve worked for some really fantastic companies in the past and the idea that I “gave up” my Oracle ACE Director and my voting board position at RMOUG seems a high price to pay when I could have gone anywhere. I do appreciate it, as many just want what’s best for me, so I do take this into consideration. I decided a while back that with all Enterprise Manager Cloud Control encompassed, that it was what I really wanted to specialize in. I spent time reading everything I could get my hands on, talked…
-
We are back to REPVFY, (Repository Verification Utility) this week, (first post can be found here…) And I’m onto the next file of substance since looking at the advisor log, (performance data). The next files are the two “details” files. One is a query used to produce the output and the second is the actual output from it. These two files are clearly named and can be found with the following naming convention: details_<timestamp>.sql details_<timestamp>.log If you are curious about what the details_<timestamp>.sql is doing as it produces the output, well you’re in luck, as I’m going to go step…
-
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…
-
The last couple weeks I’ve been lucky enough to get time with a new ZFSSA Simulator, (it will be out soon for everyone, so you’ll have to just play with the current one available, patience grasshopper! :)) and spent checking out the newest features available with Database as a Service, (DBaaS) Snapclone via Enteprise Manager 12c. I’m really thrilled with Snapclone- In two previous positions, I spent considerable time finding new ways of speeding up RMAN duplicates to ease the stress of weekly datamart builds that were sourced off of production and this feature would have been a lifesaver back…
-
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,…
-
When an agent reports that it’s blocked and needs to be resync’d, most DBAs are going to log into the Enterprise Manager 12c console and attempt a resynchronization to have it fail. A resync isn’t required very often, but if you do run into “Agent Blocked”, here are the initial steps that should be performed to have a resync complete successfully. Log onto the server that is reporting it’s blocked. If a MS Windows server, then open a command prompt “as an administrator” and go to the agent home, (this can be seen in the console under “home location” and…
-
I often have folks ask me for assistance when target discovery isn’t successful. The following is from a client’s environment that shows just how important it is to ensure your server environment is kept pristine. The goal was to discover a new database on an existing RAC cluster. The cluster had already been discovered and configured, but the DBA was experiencing a failure upon adding the database targets. Once the cluster is configured through a manual discovery using the GUID wizard, adding a RAC database is often a simple process. Just click on Targets and Databases from the EM12c console…
-
Information Publisher, (IP) Reporting has been a feature of Enterprise Manager for quite some time now, but I’ve just recently started to work with a few clients who’ve wanted to put it to use, but not implement BI Publisher, (yet… :)) If you haven’t investigated the “canned” reports that are already available to a user of the Enterprise Manager, (EM12c) then you are missing out, as there are a number that are highly valuable. Accessing the feature is as simple as logging into the EM12c console and clicking on Enterprise, Reports, then Information Publisher Reports. You will see the list…
-
Nothing is more annoying that getting alerted on things that are not critical to you or that you already know is occurring and there is not a darn thing you can do about it. I’ve also been frustrated to wake up in the morning and to see my inbox flooded with a ton of alerts from numerous EM12c systems and really- none of them are truly critical, but can appear to be simply overwhelming! How to we steer the inbox from madness to manageable? The answer to this question is not just managing metric settings and thresholds- there are a…
-
So what do you do when network hiccups and other “small” issues start to send you incident notifications that a target is down, when in fact, it was really about a target just being delayed in communicating with the Oracle Management Server, (OMS)? These are just one more way that “white noise” can drive a DBA to pull their hair out. This post will discuss ways you can eliminate this type of EM12c “white noise”. Let’s say we are receiving this incident notification, almost every night. We’ve done some research and discovered that heavy network traffic at this time…
-
As many folks know, “white noise” or having incident alerts that don’t offer value is something that I just refuse to tolerate. The metric alert “Listener response to a TNS ping is xxxx msecs” is valuable, as it represents how many milliseconds it takes the listener to respond to a network request, (i.e. ping). In the EM12c metric settings, this is set to default threshold of 400 to signal a warning and 1000 for critical. For most Listener targets, this is a solid set of thresholds, but that isn’t always the case. There are advanced logic capabilities involved with EM12c…
-
One of the greatest advancements in EM12c from previous Enterprise Manager versions is the auto-deployment. I have a number of clients with Windows environments and upon another recent search on Google, I found that there was a consistent and solid recommendation of installing Cygwin, (or another shell emulator installation) to utilize the auto-deploy. There is a large amount of work that is required to perform the pre-requisites to then take advantage of the auto-deploy, so I’m thrilled when I see someone recommend using the silent installation with Windows installation. I’m aware that I, along with others, have created posts that…
-
So as the book gets under way on the Enterprise Manager Command Line Interface, (EMCLI) I’m starting to move away from the introduction statements that I commonly was required to repeat to folks, (“it’s the return to the golden age of the DBA 1.0- command line, baby!” :)) and now are onto what has changed in release 3. The first things we want to talk about is the cool new features with Jython scripting and the the formatted output using JSON, (JavaScript Object Notation). These may not seem like much to most, but for those of us that have been…