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.

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

Oracle Database: script to purge aud$ table using dbms_audit_mgmt package

With an increase in requirements on database security, database auditing is part of most production databases nowadays. ...

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

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

Fixing Windows RAC listener to listen on IP address of Hostname

Background Recently, there was an issue after a node was added to an existing Windows RAC cluster. After everything was ...

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

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

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

Benchmark: TokuDB vs. MariaDB / MySQL InnoDB compression

Introduction As the amount of data companies are interested in collecting grows, life becomes all the more difficult ...

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