Pro-active AWR Data Mining to find change in SQL Execution Plan

Problem Statement Many times we have been called for the poor performance of a database and it has been narrowed down ...

What's new with apps password change in R12.2 E-Business Suite ?

Introduction Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra ...

RMAN - Validating Archivelog Backup

There are many posts out there about validating backup. However, none seem to address some recent concerns a client of ...

Oracle RMAN Restore to the Same Machine as the Original Database

Among the most critical but often most neglected database administration tasks is testing restore from backup. But ...

Should AUD$ Table Exist on System Tablespace During DB Upgrade?

I see this following message on all My Oracle Support notes, which talks about database Oracle manual upgrade steps.

What is the difference between logical and physical corruption in Oracle?

Room for Improvement - Using DBMS_REDEFINITION with Spatial Data

Resizing a Column in a Table With a Spatial Column Recently a client asked for help with using DBMS_REDEFINITION to ...

Availability Group - Delay with Listener Connectivity After Failover

The beauty of working for multiple clients from different industries is that you get exposed to a myriad of environment ...

Concurrent Processing Issues with Distributed Transactions Glitch

Introduction This is my first post in Pythian blog, and I wanted to share interesting use-cases that we've dealt with ...

Guide to Cassandra Thread Pools

This guide provides a description of the different thread pools and how to monitor them. Includes what to alert on, ...

Differences between R12.1 and R12.2 Integration with OAM

With the revamp of technology stack in R12.2 of Oracle E-Business Suite (EBS) , the way we integrate Oracle Access ...

A Simple Way to Monitor Java in Linux

A quick and easy way to know what is it inside Java process that is using your CPU. Using just Linux command line tools ...

Alter session kill on steroids

Efficiently Handling Persistent "Killed" Sessions in Oracle Perhaps you have encountered something like this: A session ...

Building a MariaDB Galera Cluster with Docker

There’s been a lot of talk about Docker for running processes in isolated userspace (or the cloud for that matter) ...

Changing Failgroup of ASM Disks in Exadata

Problem Statement There was a discrepancy in the failgroups of couple of ASM disks in Exadata. In Exadata, the cell ...

Oracle Passwords: How to Use Punctuation Symbols

Introduction You can’t make a password strong enough. But at least you can try. Having at least one upper case ...

Automating DataPump Export

What’s the most elaborate thing you have done with DataPump? So there I was, given the requirement to export multiple ...

What Does oracle-rdbms-server-11gR2-preinstall Not Do?

I was working on a project to clone Oracle install to a new Linux server and this should be simple as ...

SQL Server and OS Error 1117, Error 9001, Error 823

Introduction Along with other administrators, life of us, the DBAs are no different but full of adventure. At times, we ...

Small files on MapR-FS

One of the well-known best practices for HDFS is to store data in few large files, rather than a large number of small ...

How SQL Server browser service Works

Some of you may wonder the role SQL browser service plays in the SQL Server instance. In this blog post, I’ll provide ...

SQL Server replication quick tips

There is a time in every SQL Server DBA career where a mail came in with a “replication is not working, please check” ...

Virtual CPUs with Amazon Web Services

Some months ago, Amazon Web Services changed the way they measure CPU capacity on their EC2 compute platform. In ...

What Happens When Active DB Duplication Goes Wrong?

There are many blog posts out there about active database duplication. However, they were all tested in an ideal ...

SQL server error: 18056, Severity: 20, State: 29

Introduction Howdy everyone, One of the most frequent error messages I come across when dealing with SQL Server, ...

How To correlate Oracle Database transaction with GoldenGate

So there I was troubleshooting GoldenGate issue and was puzzled as to why GoldenGate transactions were not seen from ...

12c: How to Restore/Recover a Small Table in a Large Database

Introduction As a DBA, you will receive requests from developers or users, indicating that they deleted some data in a ...

List of SQL Server Databases in an Availability Group

Handling Maintenance Failures in SQL Server Availability Groups After migrating some databases to SQL Server 2012 and ...

Exploring options of using RMAN configure to simplify backup

I am a simple person who likes simple things, especially RMAN backup implementation. I have yet to understand why many ...

Data profile: better knowing your data

Problem Statement Have you ever needed to start a new data analysis project or create a report for the business users ...