Oracle

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. The growth on Oracle database audit table”‘aud$” always add spice on a DBA’s life. Since this table growth directly impacts the database performance, this table got special place on every DBA’s heart. Traditionally we follow many methods to purge…

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

As a DBA, you will receive requests from developers or users, indicating that they deleted some data in a small table in a large database a few hours prior. They will probably want you to recover the data as soon as possible, and it will likely be a critical production database. Flashback will not be enabled, and the recycle bin…

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and procedures. This can be (ab)used to create a very interesting scenario, that is not very…

In-Memory Column Store: 10046 May Be Lying to You!

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the Oracle Exadata platform, as well as the new column oriented data storage vs the traditional…

Create Windows Service for Oracle RAC

It’s my first time on RAC system for Windows and I’m happy to learn something new to share. I created a new service for database (restoredb) only to find out the ORACLE_HOME for the service is “c:\\oracle\\product\\10.2.0\\asm_1” Any ideas as to what was wrong? C:\\dba_pythian>set oracle_home=C:\\oracle\\product\\10.2.0\\db_1 C:\\dba_pythian>echo %ORACLE_HOME% C:\\oracle\\product\\10.2.0\\db_1 C:\\dba_pythian>oradim -NEW -SID restoredb -STARTMODE manual…

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 RMAN backup implementation does not use configure command, and if you have a good explanation, please share. Examples for RMAN configure command configure device type disk parallelism 2 backup type to compressed backupset; configure channel device…

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 Oracle database. I had the transaction XID correct; however, I was filtering by ACTIVE transaction from Oracle which was causing the issue. Please allow me to share a test case so that you don’t get stumped…

Changing Failgroup of ASM Disks in Exadata

There was a discrepancy in the failgroups of couple of ASM disks in Exadata. In Exadata, the cell name corresponds to the failgroup name. But there were couple of disks with different failgroup names. Using the following plan to rectify the issue online without any downtime:

Page 5 of 140« First Page...34567...10...Last Page »