Manual Creation of a SQL Profile

posted May 12, 2016, 3:17 PM by

Andy Kerber (@dbakerber), Senior Consultant

Occasionally as a DBA you will come across a query that works very well, but for some reason insists on using an index, even when you know that the index is not appropriate for that…

RHEL 7.0 Tuned Configuration

posted May 6, 2016, 4:25 PM by

by Jeff Stonacek, Principal Architect

In October of 2014, I wrote a blog describing how to use the Tuned daemon to make system settings persistent across reboots.  Specifically, disabling transparent HugePages (THP).  That blog was written with RHEL 6.x in…

vSphere 6 and Oracle RAC

posted April 29, 2016, 4:48 PM by

Jim Hannan (@HoBHannan), Principal Architect

I was fortunate enough to attend the Oracle Expert DBA Workshop with VMware last week. The presentations were excellent and reconnecting with industry experts was professionally very enjoyable. If you’re interested in learning more about…

Rename Root Volume Group

posted April 20, 2016, 10:20 AM by

by Jeff Stonacek, Principal Architect

Renaming a volume group is a fairly straightforward process, assuming that the volume group is not the root volume group. That is to say, the volume group containing the boot image and root filesystem.

The reason…

Troubleshooting Oracle Performance – Part 3

posted April 15, 2016, 10:35 AM by

Jonas Mason, Senior Consultant

Part 1 and Part 2 of this Troubleshooting Oracle Performance blog series focused on narrowing the scope and identifying problematic sessions when confronted with a general performance complaint. A troubleshooting paradigm was established to facilitate a…

Troubleshooting Oracle Performance – Part 2

posted April 8, 2016, 10:53 PM by

Jonas Mason, Senior Consultant

In my blog post Troubleshooting Oracle Performance – Part 1, I covered initial troubleshooting steps when narrowing the scope associated with a general Oracle performance complaint. I introduced the Method R approach to tuning, which focuses…

Troubleshooting Oracle Performance – Part 1

posted April 1, 2016, 4:57 PM by

Jonas Mason, Senior Consultant

In a blog post titled Oracle AWR and Statspack Reports: Performing an Initial High Level Review, I covered a general performance assessment for an Oracle instance. AWR and Statspack metrics covered in that blog are useful…

Oracle Licensing for DR

posted March 24, 2016, 2:07 PM by

by Joe Grant (@dba_jedi), Principal Architect

A frequent question that we receive from customers is “do I have to license the DR site?” As with most things in IT, the answer is “it depends.” It depends on how DR is…

Giving Away Free SQL Server Licenses… Wait What?

posted March 15, 2016, 10:51 AM by

Shawn Meyers (@1dizzygoose), Principal Architect 

On March 10, 2016 Microsoft held a #DataDriven event touting all the really cool and neat features of SQL Server 2016. One of the topics covered was that Microsoft is going to be giving away…

Death, Taxes…and Oracle Support

posted March 9, 2016, 11:53 AM by

Cameron Cameron, Senior Consultant

“In this world nothing can be said to be certain, except death and taxes.”  – Benjamin Franklin

If your enterprise is running on an Oracle database, here’s another certainty – you need to maintain Oracle Support.

Full disclaimer:…