Leveraging Your Remote DBA as a Partner

In today’s business world, management not only has to work with their current employees but a plethora of vendors. Properly managing vendors has become a crucial task for upper management, and when it comes to managing your database, the CIO must effectively communicate with the DBA vendor. Having access to the right remote DBA vendor […]

Database Rx: Refresher Course

When a person becomes sick, they seek out the advice and expertise of a qualified doctor to diagnose the medical issue. If there is a problem with your Oracle enterprise software or database, identifying the problem early and coming up with the best solution will maintain the health of your network systems. Database Rx is […]

An Introduction to Database Services

Recently, I spoke to a client who wanted to separate users into distinct groups in one of their customer-facing databases.  The client wanted to measure each group’s resource consumption so they could start to move to an “on-demand” business model and wanted to prevent one group from consuming excessive amounts of database resources at the […]

Use This 11g Workaround to Bypass Statspack Bug

If you have an 11gR2 database (we’ve seen it on 11.2.0.2 databases although it may be present in 11.2.0.3 as well) and you get this error when trying to run a Statspack snap: ORA-00001: unique constraint (PERFSTAT.STATS$FILE_HISTOGRAM_PK) violated ORA-06512: at “PERFSTAT.STATSPACK”, line 3813 ORA-06512: at “PERFSTAT.STATSPACK”, line 5079 ORA-06512: at “PERFSTAT.STATSPACK”, line 105 ORA-06512: at […]