As a heterogenous company, I get a lot of questions on what database platforms are important, why and if we should invest in them. When looking at some of the lists and some of the marketing, it can be a bit overwhelming. Now I’m not going to promise to take all of the confusion out of the myriad of database platforms out there, but I’m hoping to help with what’s relevant. Ranking So let’s take a look at what is in the list of top databases engines in the industry per db-engines.com. The reason I use this site as my main…
-
-
The Oak Table network is a closed membership of about 100 technical scientists who have a passion for technology and the world around them. These men and women, representing some of the brightest minds from each of their companies, are individuals who have built companies and major technical innovations. Initially, much of their research and work was presented at Oracle Open World. Over time, Oracle Open World welcomed less and less of their participation. They decided to create their own network and present their information at their own conference, held annually at the same time as OOW. Over a decade later, the event…
-
I’ve been going through some SERIOUS training in just over a week. This training has successfully navigated the “Three I’s”, as in its been Interesting, Interactive and Informative. The offerings are very complete and the knowledge gained is limitless. I’d also like to send a shout out to Steve Karam, Leighton Nelson and everyone else at Delphix who’s had a hand in designing the training, both for new employees and for the those working with our hands on labs. I’ve had a chance to work with both and they’re just far above anything I’ve seen anywhere else. The Challenge of…
-
I’m a Leaf on the Wind, Watch How I Soar. This is one of my favorite lines from the movie Serenity. Without Alan Tudyk’s character dying and all at the end of this, (sorry if I ruined the movie for anyone…) this is how a DBA should be in the database environment- skilled, reliable and maybe a little off our rockers. Our job is to protect the data, the database and all of the database. With that said, I’m going to list my Ten Rules of Database Administration. Fixing a performance problem with hardware is the best way to guarantee the return…
-
There was a question posted on Oracle-l forum today that should have a blog post for easy lookup for folks. Regarding your Enterprise Manager repository database, (aka OMR.) This database has a restricted use license, which means you can use it for the Enterprise Manager repository, but you can’t add partitioning to it or RAC or dataguard features without licensing those features. You also can’t use the diagnostic and tuning pack features available in Enterprise Manager on the repository database without licensing it outside of the EMDiagnostics tool. You can view information about the license that is part of…
-
After my AWR Warehouse session at DOAG in Nuremberg, Germany last week, an attendee asked me if he really needed to use trace files anymore with the value provided by AWR, (Automatic Workload Repository) and ASH, (Active Session History.) I responded that trace files were incredibly valuable and should never be discounted. To use an analogy, when I was 22 years old, and entered a doctor’s office missing a small percentage of my visual field after an apparent migraine, doctors used a number of different “tools” at their disposal in an attempt to diagnose what had happened. They first started…
-
So I’ll be heading out for Oracle Open World 2015 in just over another week. This is the first year in a while that I won’t be speaking, (my own fault, as dummy here hasn’t figured out how to submit sessions internally yet, duh!) but I’m still going to support the demo grounds, meet with customers and speak at Oak Table World! Per Steve Karam, if you need to know who’s speaking and why you should attend the sessions at the Children’s Museum, well here’s a few: Jonathan Lewis – Yes. That Jonathan Lewis. Also an alien of extraordinary…
-
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…
-
Here’s a quick guide to my schedule of sessions at IOUG Collaborate 2015 for this year. I’m looking forward to seeing everyone next week, (I’ll be arriving on Saturday, so I really should say in a couple days) and have no doubt we’re up for another phenomenal conference at Las Vegas, this year at the Mandalay! Additionally, there are some great opportunities in professional development at the IOUG Strategic Leadership Program. I’ll be speaking with James Lui on how to improve your value with personal brands and social media. I’m the WIT luncheon speaker on Monday, so for those of you that…
-
I’ve just returned from my honeymoon in Venice with the wonderful Tim Gorman, but before we enjoyed our week in this picturesque city, we spent a week doing joint keynotes and two sessions each on our own tech topics at these two incredible conferences in neighboring countries. SIOUG, (Slovenia Oracle User Group) in Ljubljana, Slovenia held their 2014 conference Oct. 13th-14th at the Plaza Hotel. Tim and I did a joint keynote, “Assumptions, the Death of First Dates and Tech Projects Around the World” which was great fun, as it’s loaded with a number of Pulp Fiction stills that transcends…
-
**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…
-
Congratulations to my coworker, Andy Colvin who just received his Oracle ACE!! Just one more immensely technically gifted individual who is very deserving of this award at Enkitec and makes me proud to be part of such a great group of folks!
-
Originally submitted at REI The REI Monorail Sling bag has the volume of a daypack and the features to meet all the challenges of the daily urban grind. Outdoor-inspired details make hauling the load comfortable and convenient. REI Monorail Sling Bag Light, Sturdy, Roomy and Comfortable!! By dbakevlar from Westminster, CO on 3/17/2012 5out of 5 Pros: Lightweight, Easy To Access Items, High Quality, Comfortable, Good Capacity, Easy To Carry, Stylish Cons: No Zipper pocket in main Best Uses: Weekend Trips Describe Yourself: Modern, Stylish, Practical, Comfort-Oriented, Career Travel Frequency: 6-10 Annual Trips Primary use: Business Was this a…
-
Due to scheduling conflict though, it’s on a Thursday evening for once! I will be presenting for the first time as an Enkitec employee in Colorado Springs, March 22nd. All you SQL Server folks out there that want to come on out, here are the details: SpringsSQL
-
I’ve been again, unfortunately, reminded what makes a poor work environment for a DBA or Developer. Eddie Awad had sent this out and the second one really resonated with me: http://www.washingtonpost.com/national/on-leadership/how-to-completely-utterly-destroy-an-employees-work-life/2012/03/05/gIQAxU3iuR_story.html?tid=sm_twitter_washingtonpost I refer to this in the IT world as the “technical bully syndrome” and it’s quite common in the arena. It’s not because it’s a male dominated group- I’ve seen bullies come in all shapes and sizes, along with being of both genders. In fact, there are a couple studies out there that say women managers and leads are more likely to bully a subordinate than a male is.…
-
Kellyn’s Schedule of Presentations, 2012, 2nd and 3rd Quarter March 24th, 2012, Colorado Springs, CO SQL Saturday Oracle for SQL Server DBA’s April 19th, 2012, Billund, Denmark MOW 2012 ASH Analytics- Top Activity, the Next Generation April 20th, 2012, Billund, Denmark MOW 2012 EM12c: Making Oracle Enterprise Manager Work for You May 30th, 2012, Hämeenlinna, Finland OUG Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 1st, 2012, Riga, Latvia JUV Harmony 2012 EM12c: Making Oracle Enterprise Manager Work for You June 26th, 2012, San Antonio, TX. KSCOPE 2012 EM12c: Making Oracle Enterprise Manager Work for You
-
Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from 10.2.0.4 to 11.2.0.2.0 and come across a couple interesting performance challenges. I do like this type of problem and have been quite busy working on the fixes for each one that has shown itself. This was one of the latest, requiring a solid, positive relationship between the developer and the DBA to solve- The DBA may have the answer, but the developer must be comfortable with the solution and make the code/design change that is required to correct the issue. I do work with…
-
As part of an 11g Upgrade, it was found that a database environment could be built from one of the upgraded databases through a duplicate. As this process had never been performed before in this fashion, a test was in order. The test was an excellent chance to discover that the OSUser that performs the duplicate process was the proud owner of a .kshrc file with hard coded Oracle variables set which was an excellent choice if you want to really screw up a new duplicate database… 🙂 Scenario: 1. Duplicate has started with correct variables set. 2. Subsequent shell…