Database Blog

Automatic SQL Tuning in Oracle Database 11g Release 2 (DBMS_AUTO_SQLTUNE)

Oracle Database 11g Release 2 (11.2.0.2 onward) has some minor changes to the Automatic SQL Tuning feature introduced on Oracle 11g Release 1. In the previous release, reports and amendments…

Read More

Flashback features of Oracle 11g

Following are the features of Flashback on Oracle 11g 1. Flashback Query, 2. Flashback Database, 3. Flashback Drop 4. Flashback Table. 1. Flashback Query – Suppose that you discover at…

Read More

Datapump 11g COMPRESSION Parameter

Prior to 11g only METADATA_ONLY and NONE could be specified. With now COMPRESSION=ALL, dumpfile size can be greatly reduced so no need to use any compression utility to compress the…

Read More

Recovery Manager (Data Recovery Advisor)

  One of the great new features of RMAN in Oracle 11g is the new tool named Data Recovery  Advisor. This tool automates the diagnose of the data failure and corruption,…

Read More

ORA-03113 and ORA-03114 Error when trying to insert on Global Temporary table.

Issue : I was getting ORA-03113 and ORA-03114  Error when trying to insert on Global Temporary table. Reproduce the Issue: Create Global Temporary table: CREATE GLOBAL TEMPORARY TABLE my_temp_table (…

Read More

HUNG IN AUTO SQL TUNING TASK

Scenario: In 11.2.0.3 database , we get alert in EM related to metric “Generic Operational Error” or “Generic Operational Error Status “. Occasionally when running Automatic SQL Tuning the following…

Read More

Query Result Cache in Oracle Database 11g

Oracle 11g allows the results of SQL queries to be cached in the SGA and reused to improve performance. Setup===== Set up the following schema objects to see how the…

Read More

How to determine if an index needs to be rebuilt.

We can get an idea of the current state of the index by using the ANALYZE INDEX VALIDATE STRUCTURE command. The VALIDATE STRUCTURE command can be safely executed without affecting…

Read More

Oracle GoldenGate Veridata Installation and Configuration

Oracle GoldenGate Veridata Installation and Configuration Oracle GoldenGate Veridata is a product that enables us to compare two sets of data and identify and report on data that is out…

Read More

ORACLE DOWNSTREAM CONFIGURATION STEPS

Oracle DownStream Replication Configuration Technical Specification

Read More