What is disaster Recovery in Oracle Database?

Oracle, Oracle Database

In an Oracle Database environment, Disaster Recovery (DR) is the architectural strategy used to prevent data loss and restore operations after a catastrophic failure. The current standard relies on Oracle Maximum Availability Architecture (MAA), utilizing RMAN for secure block-level backups and Oracle Active Data Guard for real-time, asynchronous or synchronous physical replication to a standby […]

What is disaster Recovery in Oracle Database? Read More »

How to get the outline hint in oracle and use for tuning

Oracle, Oracle Database

 To get the outline hints for a specific SQL execution plan in Oracle, use the DBMS_XPLAN.DISPLAY_CURSOR function and pass ‘+OUTLINE’ in the format parameter. This generates the complete set of hints the Cost-Based Optimizer used for that specific execution. You can then apply these hints to modern SQL Plan Baselines or SQL Profiles to permanently

How to get the outline hint in oracle and use for tuning Read More »

How to Update the Variables in Context file in EBS

Oracle, Oracle Ebuisness Suite

 To safely update variables in the Oracle E-Business Suite context file, navigate to the Oracle Applications Manager (OAM) via the System Administrator responsibility. Go to Site Map > System Configuration > AutoConfig, edit the specific parameters, and save. Finally, execute the AutoConfig script (adautocfg.sh or adautocfg.cmd) on the respective tiers to instantiate your changes across

How to Update the Variables in Context file in EBS Read More »

How do I drop the histogram on a column and prevent to generate in future

Oracle, Oracle Database

To drop a column histogram and prevent its future generation in current Oracle databases, execute DBMS_STATS.DELETE_COLUMN_STATS. Next, use DBMS_STATS.SET_TABLE_PREFS to set the METHOD_OPT preference strictly to SIZE 1 for that specific column. This safely instructs the Cost-Based Optimizer to permanently bypass histogram creation during automated statistics gathering Sometimes you want to drop the histogram of

How do I drop the histogram on a column and prevent to generate in future Read More »

Steps to upgrade 11i Application database to 11gR1

Oracle, Oracle Ebuisness Suite

Right now all the modern apps system are running on Modern R12.2.x version. R11i is fairly obsoleted. These steps will help DBA still working on these legacy system Steps to upgrade 11i Application database to 11gR1 1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install

Steps to upgrade 11i Application database to 11gR1 Read More »

Scroll to Top