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…
-
So yes, I’ve been involved in a number of conferences and in a number of different roles. I started out presenting, then volunteering at conferences, reviewing abstracts, then as a track lead and now as a conference director for RMOUG. This year I also am the database track lead for ODTUG’s KSCOPE for a second year in a row. A lot of folks have asked me recently what they need to know to submit a great abstract, how to get accepted and why they may not have been selected. It’s often a lot more complicated than what it may first seem…
-
Inspecting work area usage for memory is an important aspect of my job when I’m performing a tuning exercise. This is especially true when we are talking about specific processes vs. overall database level. Often, along with SQL enhancements, choices in source objects to a process can improve performance drastically. Most developers are focused on the results of query, especially with tight deadlines vs. performance and the DBA can often assist them in succeeding with both. The process for our example today is a CTAS, (create table as select) that has a number of joins , a union, along with…
-
So I tried to finish out some of my OOW posts, but I ended up talking about this with a friend and thought I would share how I became Facebook friends with Larry Ellison instead…. After returning from Oracle Open World 2011, I sat one day at my desk, staring in disbelief, (as many Oracle folks busy in the social media world during OOW were that day) at a friend request from Larry Ellison’s Facebook account. I accepted it and me and my fellow DBAs then reviewed the account to verify that this was Larry’s official account and yes, he’d…
-
Great day today with a second WIT session and all the interviews and General Session for Enterprise Manager 12c. If you are looking for the ebook, you can download it from Oracle here. A couple people caught on that I was tweeting while discussing the benefits of EM12c, even capturing me in a photo, (will never live it down… :)) They played the trailer for the new Cloud Odyssey movie Oracle has been working on to promote EM12c and cloud. It’s been a lot of fun as they’ve talked about how they came up with the idea based off the…
-
The ACE Director briefings are done and now we are onto Sunday sessions. I’ve already had a couple meetings with folks today and wondering why I didn’t wear flats at 2pm in the afternoon, but there are the important necessities that must be taken care of, like when am I speaking this week, so here’s the schedule: My Oracle Open World Schedule My Oak Table Schedule If you want to meet up to chat, best to hit me up on Twitter @DBAKevlar and loving Oracle Open World 2013 already!
-
This is Part IV in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level. You can read Part I, Part II, Part III and Part IV to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Tracking Warnings through the Incident Manager There were a few changes we made to metrics so that we have moved generic alert log alerts to “warning” only. We now need to add one rule to create incidents so these are logged in the…
-
This is my last WIT post on the challenges on women in the workplace. The truth of the matter is, its just too difficult to write about what women are facing in the workplace without a large amount of risk. Someone is going to view your posts on what you or someone else has experienced in the workplace as a liability or as disparaging because so often the reader sees the experience through their own eyes and not that of the writer. That’s just the way of the world and I’ve got to do right by my family first, so I’ll…
-
This is Part IV in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level. You can read Part I, Part II and Part III to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world. Incident Rule Sets There was a slight mis-communication between development groups when the Incident rules and the metric value settings were configured for the EM12c “out of the box”. Currently, 90% of metrics are only set with warning thresholds. The Incident rule sets…
-
… in any one instance the effects of [] stereotypes may be quite small- if you don’t get credit in one meeting, that’s not exactly disastrous, but over time, a little bit here and little bit there, these bias can add up and this can carry men and women into very different directions in their careers. This statement, made by Shelley Correll, Professor of Sociology at Stanford University, Director of the Michelle R. Clayman Institute for Gender Research, as part of a Lean in web education video, resonated with me as I have recognized this often in my own career and noticed…
-
I’ve had a couple peers ask me about this recently- They’ve attempted to discover targets on a host and experienced failures. This commonly occurs for the following reasons: 1. Incorrect information regarding the target exists at the target host level. 2. The OMS has an unresolved issue, status in pending state, etc. My recommendation on #2 is to always check each step as your implement EM12c, (complete the EM12c installation, adding a new host, adding a new database, etc.) Your status should be 100% green, if its not, take care of this first before you start attempting to add…
-
Many of you know that I’m the mother of three, very bright, “equally ADHD as their mother” children. As I’ve been tasked with a number of interesting challenges with both RMOUG’s and ODTUG’s WIT, (Women in Technology) events, I’ve started to investigate how, no matter what we do for women today, unless we start focusing on the women of tomorrow, we are lost. I spent some time the last couple weeks investigating the offerings by my local school districts for technical education and am alarmed for both genders. There are “Technology Plan Templates” that detail out the dismal specifications of…
-
A male peer of mine approached me just after Collaborate and discussed this incredible woman in the Oracle community that he was trying to promote and inspire. I had met her at a couple sessions and agreed- I was impressed with her knowledge, energy and intelligence as well and he asked if I would assist in promoting her- I was thrilled and agreed. I promptly contacted her via Linked in and I sent her an invite. She just accepted my Linked in request this month and it really had me thinking- It wasn’t like she hadn’t been on Linked in,…