Yeah, so I did it- I installed SQLTXPLAIN, (SQLT) on the AWR Warehouse! From previous experience with this fantastic tool, I was pretty sure I’d have some great new adventures with the AWR Warehouse data and I wanted to try and test out the AWR pieces of this tool with the Warehouse. This is a work in progress, so I’m going to do this blog in multiple parts to ensure we don’t miss anything. Installation I didn’t expect SQLT AWR features to work out of the box. I still needed to install it, run a few reports and see what would…
-
-
Just over a year ago, it became public that I was leaving Enkitec for Oracle. Most folks had similar questions surrounding my decision, including my logic in giving up my ACE Director, an assumption that I would just disappear into the Oracle “machine”, considering the sheer size of the company and with my prominent company work history, what had prompted the decision. In this last year, my career has definitely surprised more than a few folks. I, in no way, disappeared into Oracle. In fact, I’ve been made more prominent and in doing so, assisted in shining a light on the…
-
While presenting at HotSos in Dallas, Tx, an attendee, (thank you Wenju! :)) asked how page performance issues could be identified when the call was being made remotely and not from the Oracle Management Repository, (OMR) using the Page Performance console within Cloud Control. This is a very good question and although not straight forward, I would like to demonstrate what is available to assist in answering the challenge. First, I have to add that the answer is provided using release 12.1.0.4 of the Enterprise Manager 12c, so if you are still running an earlier version, your results may not…
-
I’m at HotSos Symposium 2015 speaking this week, so thought I would blog about the results of the conference I’m the director of and that finished up just two weeks ago. I’m not admitting to being overwhelmed by OEM questions here, as I’m rather enjoying it. I love seeing folks so into Enterprise Manager and look forward to more! Keep the ideas for more blog posts coming! I’ll write on all these great topics in upcoming posts. Rocky Mountain Oracle User Group, (RMOUG) Training Days 2015 is over for another year, but the conference is a task that encompasses approximately…
-
I’ve been running the Women in Technology, (WIT) at RMOUG, which I first started planning out in 2011, which has grown to include other user groups and even countries as its grown. The last couple years, I’ve worked to try to add a WIT scholarship to RMOUG’s, but it wasn’t always easy to convince others that we should provide one when you are asking to choose one group over another. There’s only so much money to go around and so many initiatives that we need to address each year for the Oracle community. For 2015, we had a unique candidate…
-
Collaborate 2015 at the Mandalay in Las Vegas is just around the corner and the sheer amount of Enterprise Manager focused content is phenomenal! Oracle partners and power users around the world come together each year to provide the lucky attendees the best in use cases, tips and technical know -how regarding the best infrastructure management tool in the industry. If you are one of the lucky masses who attend this incredible conference from IOUG, Quest and OAUG, you’ll be searching the massive schedule of sessions for the presenters that will get you to the level of expertise you desire…
-
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 database and THEN use the ADDM Comparision Report to view the “What if’s”? This is where Database Replay really enhances the comparison report feature. along with…
-
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 report. Top Activity In our EM12c environment, we note some high activity in a database and use Top Activity to view what’s going on: As…
-
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 statspack. 2. Was always on, meaning that the data would continually collect without manual intervention from the database administrator. 3. Wouldn’t impact the current processing,…
-
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.4 installation and shouldn’t be edited or reconfigured, but I think it’s good to know where everything is if you should ever need to investigate it or are…
-
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 aspects of a single instance must always be examined, knowing what is unique to RAC is important. Be aware that Enterprise Manager is completely RAC Aware…
-
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 and all of IT) and then the AWR Warehouse, which shares it’s user interface as part of cloud control, that currently is a DBA’s deep analysis and research…
-
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 know there are a lot of other tasks that could be better use of their time. Patching is still an essential and important task that must…
-
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. DBAKevlar Blog 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 included. This post describing the easiest deployment method has continued to be my most popular post. I admit that I’m not too thrilled that it…
-
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 to me, I have a great career, great peers and wonderful bosses. It was the right choice for me and I ignored a number of people who would have…
-
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 page with the Statistics Status and go up into the links. Viewing the graph, you get a quick and clear idea of the status of your…
-
OK, Oracle EM hat off, RMOUG Training Days hat on! 🙂 So as many of you know, RMOUG Board of Directors made the smart move after I joined Oracle, instead of losing a valuable member of the board, they moved me to being a non-voting board member emeritus and realized that I could still serve as the Training Days Conference Director. The conference is by far, the most demanding position on the board and its a role that I relish and have the skills for. Oracle is happy. RMOUG is happy. Membership is happy. Training Days is taken care of……
-
While enjoying the lovely Liverpool, UK weather at Tech14 with UKOUG, (just kidding about that weather part and apologies to the poor guy who asked me the origin of “Kevlar” which in my pained, sleep-deprived state I answered with a strange, long-winded response…. :)) a customer contacted me in regards to a challenge he was experiencing starting an agent on a host that was home to 100’s of targets. oracle_database.DB301.com - LOAD_TARGET_DYNAMIC running for 596 seconds oracle_database.rcvcat11 - LOAD_TARGET_DYNAMIC running for 596 seconds oracle_database.DB302.com - LOAD_TARGET_DYNAMIC running for 596 seconds oracle_database.B303.com - LOAD_TARGET_DYNAMIC running for 596…