Category Archives: Uncategorized

Detecting Source of MySQL Queries with Comments

As a MySQL DBA I already know the data changes that happen on my system. I have logs for that.
However, it’s a common problem that several years into the life of an application, the current developers won’t know where in the codebase querie…

Pythian’s Annual MySQL Community Dinner at Pedro’s

Once again, Pythian is organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members since many of you will be in town for Percona Live that week. Here are th…

Travelling in a Wheelchair

It’s that time of the year again, when one of the best grass roots Oracle user group conferences takes place, the Rocky Mountain Oracle User Group Training Days in Denver Colorado. I’ve been privileged enough to present at this conference …

Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization

Topic: This post is about the latest updates to PerfSheet4 v3.7 (February 2015). PerfSheet4 is a tool aimed at DBAs and Oracle performance analysts. It provides a simplified interface to extract and visualize AWR time series data using Excel piv…

Log Buffer #409, A Carnival of the Vanities for DBAs

This Log Buffer Edition sheds light at some of the nifty blog post of the week from Oracle, SQL Server and MySQL.
Oracle:
Patch Set Update: Hyperion Data Relationship Management 11.1.2.3.504
The Hitchhiker’s Guide to the EXPLAIN PLAN Part 33: The mot…

Log Buffer #410, A Carnival of the Vanities for DBAs

This Log Buffer Edition spread love of databases just before Valentine’s Day. Lovely blog posts from Oracle, SQL Server and MySQL are here for you to love.
Oracle:
Creating a Mobile-Optimized REST API Using Oracle Service Bus by Steven Davelaar.

DBMS_STATS.PURGE_STATS

Prior to 11.2.0.4, DBMS_STATS.PURGE_STATS does a slow delete of stats before the parameterised input timestamp.
Why might you be purging? Here’s one such illustration:
https://jhdba.wordpress.com/tag/dbms_stats-purge_stats/
This delete can be slo…

MobaXterm 7.5

MobaXterm 7.5 has been released. You can find the downloads and changelog in the usual places.
If you are a Windows user, MobaXterm is by far the best tool I’ve ever found for SSH and X Server functionality. It’s much simpler than using Cyg…

Transparent Data Encryption (TDE) in 12c and RTFM Carefully

I keep thinking I’m moving forward with this Oracle database 12c stuff, but around every corner there is another surprise. A few days ago I was setting up a demo for Transparent Data Encryption (TDE) in 12c using my existing articles (10g, 11g)….

Oracle Security Training, 12c, PFCLScan, Magazines, UKOUG, Oracle Security Books and Much More

It has been a few weeks since my last blog post but don’t worry I am still interested to blog about Oracle 12c database security and indeed have nearly 700 pages of notes in MS Word related to 12c security….[Read More] Posted by Pete On 28/08/13…