GigaOm x Pythian: Realities and Risks of Enterprise AI
In a recent interview on the Business Disruptions in Tech podcast, Howard Holton and ...
Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn't ...
Problem Statement Have you ever encountered this error connecting to a DB using global authentication against OID? Was ...
Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used as the storage ...
We recently received this inquiry from a client: "C an an Oracle database account support two passwords at once so we ...
Recently we've seen a strange problem with the deadlocks at the client database on Exadata, Oracle version 11.2.0.4. ...
I worked on root cause analysis for a strange node reboot on client's Oracle Database Appliance yesterday.
Background I ran into a situation where we needed to recover from an old online backup which (due to some issues with ...

After migrating a 10g database to 11g, I asked the Application team to start their tests in order to validate that ...
I've been working on setting up a demo for my upcoming presentation on application continuity at RMOUG training days ...
Background Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query ...
Hello, In this post I will explain how to set up Cassandra monitoring with influxDB and Grafana. This can also be used ...
Context Azure SQL Database is Microsoft’s Database as a Service (DBaaS) platform offering. It allows end users to ...
Introduction: The Virtual Core Discrepancy Update 2015-May-11: Jean-Michael dug up another Amazon Web Services document ...
In an Oracle DBA's life, you'll be regularly asked to work on applying a new patchset on a database and then you will ...
Migrating Oracle to Amazon RDS with Minimal Downtime Amazon RDS is a web service used to manage databases, like Oracle, ...

An Introduction to Apache Cassandra As some of you may know, in my current role at Pythian I am tackling OSDB, and ...
Introduction If a lot of rows or pages are locked, the SQL Server escalates to a table-level lock, to save resources. ...
Roughly speaking, the notion of 'Tables' in Oracle is similar to MongoDB's 'Collections'. They are NOT identical ...
I discovered ASM with a 10.1.0.3 RAC running on Linux Itanium and that was a big adventure. At this time there was no ...
Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding ...
Troubleshooting an EM12c Login "Authentication Failed" Error So the other day I was trying to log in to my EM12c R4 ...
When you try to rollback a weblogic patch in Oracle EBS R12.2, you might run into issues similar to below:
Background As a MySQL DBA I already know the data changes that happen on my system. I have logs for that. However, it’s ...
There are many ways to migrate a database from A server to B server like Datapump, RMAN,etc. Using the combination of ...
As with any database administration strategy, management of Redshift requires setting and revoking permissions. When ...

The Resilience of Apache Cassandra: An Introduction This blog is a part 1 of a 2 in a series. This will be different ...
It’s public knowledge that the traditional patching tool in Oracle EBS “adpatch” is replaced with “adop” utility. It’s ...
Test Case Preparation I’ve been making some tests recently with the new Oracle 12.1.0.2 In-Memory option and have been ...
Suspending and Resuming Access A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you ...
Introduction One of the lesser known new features that comes as a boon to many developers and DBAs is the provision of ...