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

Troubleshooting Oracle's Auto Service Request

I've spent the better part of the day troubleshooting an issue with Oracle's Auto Service Request (ASR) and wanted to ...

Statistics gathering and SQL Tuning Advisor

Our monitoring software recently flagged a long-running job on a client database: an Oracle auto-task for statistics ...

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

How to move Oracle DB to New Oracle Home on Same Windows Server

I have been thinking about writing a Pythian blog for long time, and today I finally took the opportunity. In the DBA ...

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

How to recover a subset of an Oracle database

Today's blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across ...

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

getMOSPatch.sh - Downloading Patches From My Oracle Support

The transition away from FTP access in My Oracle Support (MOS) several years ago introduced a significant hurdle for ...

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

Batched table access

When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind ...

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

How to Download Oracle Software Using WGET or CURL

This is yet another blog post with tips and tricks to help you (and me) download Oracle software without the help of a ...

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 Apply a Standby-First PSU Patch in a 2 node RAC environment

Oracle provides since it’s 11.2.0.1 version a way to apply certain patches, to our standby environment first, without ...

Disabling Triggers in Oracle 11.2.0.4

In March 2012, I put together a blog post entitled Disabling Oracle triggers on a per-session basis, outlining a way to ...

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

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