So back at the end of the EM CAB, I’d received an email stating I had an over-sized database and too many hits to continue on Go Daddy as the host for my website. I called into tech support to understand what options I had, but was never told that I had any option but leaving Go Daddy as my hosting service. I was told I had two weeks per the email, but asked for three and was told on the phone that wasn’t a problem. I then did some research and decided that Blue Host had done well supporting…
-
-
Every so often a DSS query that usually takes 10 minutes ends up taking over an hour. (or one that takes an hour never seems to finish) Why would this happen? When investigating the DSS query, perhaps with wait event tracing, one finds that the query which is doing full table scans and should be doing large multi-block reads and waiting for “db file scattered read” is instead waiting for single block reads, ie “db file sequential read”. What the heck is going on? Sequential reads during a full table scan scattered read query is a classic sign of reading…
-
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…
-
This is the first of many posts I’ll do where we take a particular issue and trouble-shoot. I’ll go through multiple scenarios to show the common steps to take via the Enterprise Manager 12c from discovery to identification to research to explanation. This blog will use the following features: ASH Analytics SQL Details ASH Report The first thing we need is an issue- Note the CPU red line- the IO is considerably over that and quite a lot of IO, along with Commit and Concurrency waits. We’ll start with this as our issue that we can see, has quickly escalated…
-
There are a number of Verification Utilities for Enterprise Manager 12c, (EM12c) and I’ve written about them before, but today I’m going to start on the Repository Verification Utility, (REPVFY). This will be an ongoing series, as there are so many valuable features rolled into the utility and new ones that will be added as new patches and releases happen. For this post, I’m going to be reviewing a level 2 diagnostics report from a new repository database. This is going to offer us all kinds of valuable data about the environment and should be considered by any EM12c administrator…
-
Now that we learned in Part I how to create a notification schedule for a specified user so that it will only page one individual on an oncall rotation, I’ll now show you how to use this in conjunction with rulesets to complete the process of modernizing and automating your oncall. In my Test scenario, I’ve already made copies of the main rule sets, have deviated rules by three rules and four groups, (mission critical, production, test and development.) Mission critical are all systems that I WANT to be paged for after hours and need to know immediately if there…
-
I came across a discussion on Oracle-l on how after hours paging was handled for many companies and was kind of surprised how many DBAs still carry around a secondary pager/cell phone or are just expected to be woke up if on call or not. I’m not one to go back to sleep once I’m woke, so I’ve been a proponent of EM notification schedules for after hours paging. Now there are other ways to handle this in Enterprise Manager 12c as well, but we’ll use this method, as it is backward compatible to OEM 10g, too. The requirement of…
-
Lately I’ve been having more discussions on securing the EM12c environment. All of IT has a tendency to treat the Enterprise Manager as a afterthought in both hardware allocation, as well as security best practices. No one is sure of exactly why this is- they all have their theories, but we do know it happens often. Today we are going to go over some of the auditing options within EM12c. Basic auditing is turned on by default in the environment, but only covers basics processes. There are over 150 auditing options and extensive information can be collected, retained within the…
-
I know that folks have been having some challenges downloading my slides from Collaborate for a couple of my sessions and I know I’ve received errors when updating two of them the other day, so I’ve added them to my slideshare location for your convenience. Thank you for everyone who attended my sessions- such great turn outs and fantastic attendee participation! I had some real EM12c stars in the audience and appreciated the support and banter! My slideshare list for download can be accessed from here. Thank you to IOUG, Oracle and everyone for their support!
-
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…