Data Recovery: Practice A Little “RMAN Over-Kill”

Note: This blog was posted on behalf of Gary Parker, Senior Enterprise Data Architect and Consultant at Performance Tuning Corporation. If you’ve worked as an Oracle DBA for any amount of time, you’ve probably come to realize that one of the most important aspects of your job is to insure that you implement a [...]

By | 2017-09-20T08:18:51+00:00 March 3rd, 2015|Performance Wire|Comments Off on Data Recovery: Practice A Little “RMAN Over-Kill”

What is Database as a Service?

We’ve started to hear this term coming up more and more as we meet with clients and partners – and while there isn’t a consensus on just what it means there are some definite benefits to exploring the concept sooner than later.  For most of our clients what moving anything to a “Service Model” [...]

By | 2017-09-20T08:29:39+00:00 April 18th, 2014|Out Perform|Comments Off on What is Database as a Service?

UnOptimized Reads in Oracle Database 11gR2

Many of you who have been reading statspack or AWR reports might be wondering what is the new category of "SQL Statistics; SQL ordered by Physical Reads (UnOptimized)".  What is an UnOptimized read? To begin, we need to clarify the meaning of the statistic. For systems not using Exadata Hardware and the Oracle Database [...]

By | 2017-09-20T08:36:47+00:00 December 2nd, 2013|Performance Wire|Comments Off on UnOptimized Reads in Oracle Database 11gR2