I’m thrilled to see the outpouring of support for EM13c already out with it just being announced on Friday! As technologists all over the world jump in and start installing the newest and greatest version of Enterprise Manager, there is a second group already working on the task of upgrading their existing EM12c environments, (seen a few already, including one from Gokhan!) Along with other requirements, like setting optimizer_adaptive_features set to false, there is pre-requisite that I’d like to recommend that everyone perform on any EM12c environment before endeavoring on an upgrade- do a health check with EM Diagnostics. Enterprise…
-
-
If you haven’t been watching the latest Oracle news, Enterprise Manager 13c is out! You can get all the latest information on newest features that were included in this release here and download it from OTN here! Merry Christmas everyone!!
-
Working with test data is always fun and teaches those of us inside Oracle how best to use the new products that will be offered to benefit customers. To me, it’s pretty straight forward and I didn’t first understand why it was necessary, but as I sit in on calls as we do performance testing of these great, new products, I understand why they need to direct so many, so often. Anything performance is as much a mindset as it is a science. Application Performance Monitor, aka APM, is no different. I didn’t exactly “follow” the hands on labs each time we’ve been…
-
So I’m about to depart for one day in San Antonio, Tx. to present at the International Performance and Capacity Conference, but I wanted to try to get another blog post out, this time regarding my survival at the 2015 Oracle Open World. I’m not sure if it just that the schedule was a month later than usual or that it was just more demanding this year, but I left on Friday, feeling utterly exhausted and judging by the tweets and posts from others on social media, I don’t think I was the only one! I always regret what I didn’t…
-
This is one of about 40 blog posts I’ve been eagerly awaiting for permission to post on the Oracle Management Cloud, (OMC)! There are three main products that will be offered initially through the Oracle Management Cloud– Application Performance Monitoring, (APM) Log Analytics IT Analytics This post will focus on one area of the third offering of IT Analytics– Database Performance Analytics. How can advanced IT Analytics investigate database performance at the cloud level vs. on premise? We’ll take a look deeper into this Oracle Management Cloud feature today and hopefully give you just a taste of this incredible upcoming suite…
-
There is an incredible power with the simple act of doing. People have a tendency to complain about the world, but there are only a few that refuse to simply accept it as it is and reach out to change it. The Gift, The Anarchy This video with the Red Pill Analytics guys, Stewart and Kevin, was a great opportunity to talk about something that is very important to folks like Jeremy Harms, (@EmeraldCube) and I. Jeremy is very active in the Atlanta area with his Code Crew events, introducing technology to locations that may not have the resources to…
-
I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks. Indianapolis Oracle User Group I spoke at the INOUG back on September 17th. The user group in Indiana is incredibly welcoming and I had a great time with the wonderful attendees for my three back-to-back sessions. We discussed AWR Warehouse, ASH and AWR Mining and a new session on Optimization for EM12c and the Hybrid Cloud. East Coast Oracle Conference September 21st-23rd was my first visit to the great city of Raleigh,…
-
So I’m going to start this post with an admission- I don’t have access to a cloud environment to test this out, but I know what I would do first if I experienced slow response time on database creation or cloning via EM12c to the cloud and I would like to at LEAST post what I would do to give others the chance to test it out and see if it offers them some help. Knowing what is causing slow performance is essential to trouble shooting any problem. I’ve had a few folks come to me with complaints that their hybrid…
-
As the Training Days Director for Rocky Mountain Oracle User Group, one of my tasks is not just running the conference for RMOUG, but also promoting it. RMOUG Training Days was the first conference I ever attended, (2004) and the first one I ever presented at, (2009.) Its one of the reasons my career is where it is now and how I stayed in touch with the man who is now my partner in life, best friend and husband. The Training Days conference is the largest regional Oracle User Group conference in the US and is held each year…
-
Everything I do with the Raspberry Pi is about finding ways to incorporate STEAM, (Science, Technology, Engineering, Art and Math) into my projects. This is no easy feat, but I have a lot of fun while I try. This latest project, we’re still working on ways to “enhance” and understand how code can be used with multiple projects and to satisfy multiple requirements. Science Kit Projects, to the Nth Level Our first project used DC motors to make an art project or spinner turn at the appropriate rotation required. I then was able to repurpose this same code to bypass…
-
Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action. Enterprise Manager also removes some of the syntax options that could get a developer or app support person that is less specialized in creating trace files, all the options and the knowledge of the syntax, etc. from getting into trouble, which creates an option for everyone to be successful. The proposed solution that I’ll post here is where the EM12c user will be able to create trace files, but the DBA will control the…
-
There’s an old joke about the evolution of a programmer. It starts with the programmer in their infancy and typing: Print “Hello World” and so the output returns: The programmer continues to evolve. His coding knowledge increases and his code in the end of his evolution becomes a script of 5000 to 10,000 lines. What does the output return? You guessed it: I often joked that I’d make a terrible developer. I over think everything, but the truth is, I may have just evolved too much and need to devolve to improve. There used to be a sign up on…
-
So I’m working on a lot of posts for Enterprise Manager, but I can’t post them just yet, so here’s some more Raspberry Pi love to keep you busy until then… 🙂 Why VBox Raspberry Pi? Many times I just want to write and test some code, but I want to do it while I’m taking a break from my day to day work- waiting for a download, in a meeting, a script is running in another window, etc., so it’s convenient to have a Virtualbox image to run Python scripts with all the libraries and modules installed. I can’t…
-
I’ve had a lot of people email and message me asking me what I’m doing with the Raspberry Pi and I wanted to share before the actual RMOUG Quarterly Education Workshop, (QEW) this Friday at Elitches. So a little history- When I was a kid, I was a real handful. My mother used to come into my room and I’d have created “webs” out of yarn strung from every piece of furniture and twisted into patterns. I used to take apart radios and use the parts to create new toys, figuring out how the electronics worked. Dolls suddenly became cyborgs…
-
Happy Birthday to me! So for my birthday, I give a present to you… As I want all DBAs to sleep better at night, here are the top ten features you can use in Enterprise Manager Cloud Control to offer a good night’s rest instead of during the day at your desk… 🙂 1. Disable the Default Rule Sets Shipped with Cloud Control. Yes, you heard me. I believe you should use them as a starting point or an example, but don’t put them into production. These were examples set by development to see all that you could be notified…
-
I had a chance to take a closer look at the Zero Data Loss Recovery Appliance, (ZDLRA) via Cloud Control today and really liked the dashboard that’s included in the plugin for the product. This post isn’t going to cover the installation of the plugin or configuration- I was just intrigued by the dashboard and wanted to go over the great features that are part of it. Accessing the ZDLRA As with any Targets, the ZDLRA is going to show up in the All Targets menu and also has a target type filtered drop down in the Targets menu. All…
-
When you need to have information about one SQL_ID and don’t need everything and the kitchen sink, there are a few different ways to collect this via Oracle. I’m surprised how rarely this is covered in performance tuning/optimization, (whatever the current “acceptable” term is for fixing a database when there are performance issues arise… J) classes, manuals and documentation. I’d like to cover two of my favorite here and know, there are other options that I won’t be digging into, (SQLd360, SQLTXPLAIN, tracing, etc…) The Workload Repository SQL Report I also refer to this as the “SQL ID Specific AWR…
-
There may be a reason that one needs to re-add a database to the AWR Warehouse. This is a new opportunity for me to learn and offer assistance, but I’m working off the grid to figure out a solution. Luckily, it’s just a matter of creating a new process from pre-existing code and processes. The process requires both the AWR Warehouse UI and a SQLPlus connection. 1. Disable the snapshots 2. Extract the AWR for the Database 3. Drop the database from the AWR Warehouse 4. Add the database back into the AWR Warehouse with the retention time or any…