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 ...

Untold Secrets of SQL Server: What if?

The Strategic Use of Undocumented Commands It's common practice for IT vendors to keep some of the commands and ...

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.

SQL Server Statistics: Maintenance and Best Practices

What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more ...

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 ...

Purge statspack snaps of source db on test db having different DBID?

As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms version 9i. Thanks ...

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, ...

How To Improve SQL Statements Performance: Using SQL Plan Baselines

The performance of any Oracle database heavily relies on query execution(s). The reasons for any SQL statement’s ...

Do AWR Reports Show the Whole Picture?

Introduction AWR report is a great source of aggregated information on top activities happening in our databases. I use ...

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 ...

Merge Replication Identity Range Management - An Identity Disorder? Part 2

In Part 1 of this series, we explored Merge Replication Identity Range Management of tables with identity columns. We ...

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 ...

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 ...

Script to Collect Database Information Quickly

As a DBA, there are occasions where we are required to collect details from a database which can be used for further ...

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 ...

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 ...

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 ...

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 ...