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 MoreFollowing 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 MorePrior 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 MoreOne 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 MoreIssue : 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 MoreScenario: 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 MoreOracle 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 MoreWe 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 MoreOracle 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 MoreOracle DownStream Replication Configuration Technical Specification
Read More