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,…
-
-
I was warned it would be difficult. I was warned that it would be time-consuming and painful, but I survived without as much as a scratch on me. This last week was my first week at Oracle and it was really, really great. The on board process wasn’t difficult at all. Maybe it was because I was told to be prepared for a difficult and challenging week, so I was prepared for something very difficult and it was much easier than I imagined. Maybe it was because I had new challenges and interesting new environments to work in, which made…
-
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’m in the midst of transferring over to my travel laptop to run all my VMs on and retiring my previous ASUS work laptop to my youngest son. I was surprised to find out that not ALL laptops are set up to run virtual environments these days. 1. Virtualization may not be enabled in the BIOS, (i.e. On-Boot UEFI in the Lenovo Yoga 11s.) Once this is enabled, save the configuration and reboot, allowing you to now run a VM on your laptop. If you are importing appliances, make sure you have set the location to import the disks to the…
-
I love my Lenovo Yoga 11s special build, ultra book. It has 16G of memory, an Intel core i7 and 256 SSD, but that’s no where near the amount of space that I’m going to require to be running numerous virtual environments on it. To help me out, I went on a fun buying and testing spree with a number of external disk solutions to find what worked best for my needs. The contenders, (yes, I was all over the board on these)- The Toshiba Canvio 5400RPM, 500GB external drive The Touro 1TB 7200RPM, USB 3.0 external drive The…
-
Yes, you heard that right- DBA Goth Cowgirl is getting an upgrade to Enterprise Manager, (EM12c) Goth Cowgirl! I will be starting as Oracle’s Consulting Member of the Technical Staff for the Strategic Customers Program, specializing in Enterprise Manager on March 17th. The Strategic Customer Program is a group that rolls up under the Systems Management product line and is one of four primary product lines, (the other three being Database, Fusion Middleware and Applications.) We comprise the whole of Enterprise Manager and OpsCenter. This opportunity has been long in the making and I look forward to focusing on the…
-
Today is my last day at Enkitec and I look back on a whirlwind two years. As many people know, I never seem to stop moving, (I hear my mother’s voice from when I was a small child saying, “Kellyn, sit down! Kellyn, don’t climb! Please, sit still!” :)) Nope, still doesn’t work, but I also never seem to stop growing and it’s time to take that next step in my career. These last two years have been phenomenal, starting out as a new Oracle ACE and a flurry of conference appearances, it’s culminated to me speaking at 16 conferences,…
-
A number of folks have told me how much they enjoy the content that I “buffer” out throughout a 24 hr automated period, but hate how much they often miss vs. getting “spammed” with all of it at once and just being overwhelmed. I’m trying to find the best of both worlds and have started to push this content out to my very own Flipboard magazine. If you love Flipboard and would like to find the stories of interest I push out on Twitter, Facebook and Linked In, you can now subscribe to DBA Kevlar Ammo and get all the…
-
I know, I know… Just answering questions that I keep receiving from folks repeatedly, so if you know this one, love ya, if you need this answer, here it is! 🙂 To secure/unsecure or to resyncronize an agent, you need the agent registration password. This would have been created when you performed the installation and configuration of the Enterprise Manager 12c. If you didn’t perform the installation or you’ve just started to support it, you are most likely scratching your head and asking where could so and so have put that password?!?!? No fear- you can add one to be…
-
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…
-
So I survived one more year as the conference director for RMOUG Training Days 2014! 🙂 There was some question to my survival as we entered the week before the conference, but I can say, I’m surprisingly intact and once I finish this post, it’s onto the next challenge! If you’re unfamiliar with the conference, Rocky Mountain Oracle User Group’s Training Days has been an incredibly well supported conference by many of the best Oracle speakers, Oak Table members and ACE/ACED in the world. I’m very proud to be a member, a board of director, as well as the conference…
-
Training Days 2014 for RMOUG starts in just TWO days. Tim and I have picked up Jonathan Lewis and Pete Sharman this weekend, the flurry of speakers will be arriving in the next couple days. With the fantastic help of Team YCC, we have an incredible conference planned for everyone! If you haven’t downloaded the Guidebook mobile app from the App store or Play store, do so, as you can’t miss out on this great application to make the most of the conference. You can build your schedule, read up on Speaker/exhibitor bios, keep up with all the going on’s…
-
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…
-
This post is to clearly discuss an opinion I have on where I think we’re failing our current and next generation on technical education. So I’ll start out with a disclaimer. 1. It’s my opinion and no one else’s. Not my employer, not my genders and not anyone but mine. 2. Its a whole lot easier to write here in a blog post than in a twitter conversation, no matter how much I enjoy chatting with everyone, including Jeff Smith and Bradd Piontek… 🙂 The basis for the discussion was an article that can be found here. Although the article…
-
**Note- This is an article I wrote about 4 years ago that, as far as I know, can only be found in hard copy and although I’ve changed my stance on statistics, etc. with 11g/12c, the main point of CTAS benefits still stands the test of time. As a kid did you ever watch the cartoon Hanna-Barbara’s, “the Jetson’s” and see Elroy drop out of George Jetson’s flying saucer, going to school via his personal, hyper-pod and thought, “forget the bus, I want to go to school in the hyper-pod!”? For any developer or DBA working with large objects…
-
I’ve been working a good number of hours this December between project/clients for Enkitec and co-author work on the EM CLI book with Seth Miller and Ray Smith, plus my additional responsibilities as the Training Days Conference Director for RMOUG’s big conference coming up in 6 weeks. Due to all of this, going to take one more blog post off from technical and share what happens when you eat food outside of your normal diet just before going to bed… —————————————————————————————————————————————————————- Saturday evening we were returning home from a wonderful post-Christmas dinner at Tim’s Mother’s home. We had quite a…
-
Anyone who knows me, will also know that I’m an Android person. I have nothing against Mac products and really do think they are cool, but I use what works for me and I am very content with my Samsung Android Galaxy S4 for my Smartphone and Galaxy Note 10.1 for my tablet. With the innovation of wearable smart devices, one would think that I would have gone Galaxy Gear, but I didn’t. Here are the initial reasons my letter to Santa had the Sony SmartWatch 2 instead: Play Store wise, the Sony had just as many and actually had…