Oracle 11g Release 2 Pre Upgrade tool utlu112i sql
This article shows what to do for different warnings and cautions reported by Oracle 11g Release 2 Pre-Upgrade tool that is utlu112i.sql during 11gR2 upgrade.
Change or switch undo tablespace in Oracle database
A frequently asked question on different Oracle forums is; How do I change the UNDO tablespace for my database and drop the old one? This post shows how.
Oracle 11g DBMS_FLASHBACK TRANSACTION_BACKOUT
This article shows how to perform a Flashback Transaction manually using DBMS_FLASHBACK.TRANSACTION_BACKOUT in the absense of Oracle Enterprise Manager.
Oracle 11g Flashback Transaction in OEM LogMiner Interface
Oracle 11g introduces a new feature called Flashback Transaction that can be used to rollback a whole transaction. This article explains how this works.
Upgrade Oracle 10g Release 2 from 10201 to 10204
This post demonstrates a step by step guide to apply oracle patchset 10.2.0.4 (patch number 6810189) on 10.2.0.1 database hosted on 32-bit RHEL 5.4.
Oracle 11g Using LogMiner to analyze redo log files
Oracle 11g LogMiner has been incorporated into Oracle Enterprise Manager to analyze the redo log files. This article shows how it works with example.
TDE in Oracle 11g and Transparent Tablespace Encryption
Oracle 11g introduced transparent tablespace encryption feature in Oracle advanced security. This post explains how it works with its performance improvements.
Oracle 10g Transparent Data Encryption examples
Oracle 10g transparent data encryption (TDE) is a powerful feature to hide sensitive data. This post shows how to use TDE along with performance considerations.
Using Oracle LogMiner to undo incorrectly committed changes
How to analyze redo log files for changes happened on certain time or SCN range using LogMiner and how can we recover data loss from user errors with UNDO SQL
How to read or analyze redo log files using LogMiner
How to use LogMiner in Oracle 10g: This article shows how to read/analyze online/archive redo log files using Oracle LogMiner through a sql interface.