DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!


Why ALL Tools in at Your Disposal ARE IMPORTANT

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 […]


, ,

Oracle Open World and Oak Table World Schedule!

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 […]


, ,

Re-Adding a Database to the AWR Warehouse Without Losing Historical Snapshots

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 […]



DBAKevlar at Collaborate 2015

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 […]



SIOUG and HROUG Fall Conferences, 2014!

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 […]


The CTAS, a.k.a. Processing Data the Jetson’s Way

**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 […]


Andy Colvin is Now an Oracle ACE!

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!


My Review of REI Monorail Sling Bag

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 […]


SQL Saturday Presentation!

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


The Technical Bully Scenario

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 […]


Kellyn’s Presentation Schedule, Spring/Summer 2012

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, […]


11g, Sherlock Holming it with Statistics, Histograms and Bind Peeking

Yes, my dear Watson, Bind Peeking is still an issue in 11g…. We recently upgraded from to 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 […]


Restarting a Duplicate Process From a VERY Failed State

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 […]


The NO_INVALIDATE Option in DBMS_STATS with 10g

I had worked hard on a report, 47 SQL statements in all to tune it down from 5 hrs to under 30 minutes.  The first runs had been quite successful, so when a third run sent an alert on temp usage, I knew something was wrong. SID PROCESS MACHINE SQL_TEXT SQL_ID TOTAL MB ——– ———— […]


  • Facebook
  • Google+
  • LinkedIn
  • Twitter