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

Performance issues with the Sequence NEXTVAL call

Is SELECTing from a sequence your Oracle Performance Problem? The answer to that question is: it might be! You wouldn't ...

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

ORA-28043: Invalid bind credentials for DB-OID connection

Problem Statement Have you ever encountered this error connecting to a DB using global authentication against OID? Was ...

The power of the Oracle Database Proxy authenticated connections

We recently received this inquiry from a client: "C an an Oracle database account support two passwords at once so we ...

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.

Using the ILOM for troubleshooting on ODA

I worked on root cause analysis for a strange node reboot on client's Oracle Database Appliance yesterday.

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

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

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

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

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

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

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

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

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

An introduction to extended data types in Oracle 12c

Introduction One of the lesser known new features that comes as a boon to many developers and DBAs is the provision of ...