DBA Kevlar

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


Application Performance Monitoring- First View

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


Oracle Open World 2015, Survival of the Fittest!

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



IT Analytics- Global Database Performance

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


Be the Change You Want to See

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



Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

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


, ,

Recommendations to Address Cloud Performance Issues via EM12c

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


Submit an Abstract to RMOUG Training Days 2016!

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


Raspberry Pi Controlled Airplane Launcher

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


Creating a Trace File from EM12

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 Evolution of a Programmer and the Pythonic Way of Thinking

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



Emulating a Raspberry Pi on Virtualbox

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



Upcoming Raspberry Pi Family Coding Day Project

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


, , ,

Ten Things in Enterprise Manager to Improve a DBA’s Sleep at Night

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


, , ,

Zero Data Loss Recovery Appliance with EM12c, (ZDLRA)

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



SQL ID Specific Performance Information

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


, ,

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



ASH Data and How Sizing an AWR Warehouse Can be Mitigated

When sizing the AWR Warehouse, one of my requirements is to have certain reports for a sampling of databases that will source the AWR Warehouse. This report provides me the right information to create the correct sizing requirements vs. any assumptions done with other choices. The report is the General AWR Information report and can be […]


, ,

SQLd360 with the AWR Warehouse

Mauro decided to give me another challenge-  run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”.  It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installation of any packages…) I chose a SQL_ID from one of the source databases loaded and ran […]


, ,

Previous Posts

  • Facebook
  • Google+
  • LinkedIn
  • Twitter