How to generate EPM Deployment Report

hyperion, Oracle

To generate a deployment report for an on-premises Oracle EPM System, open a command prompt on the Foundation Services host machine. Navigate to the EPM_ORACLE_INSTANCE/bin directory and execute the command epmsys_registry report deployment. Oracle will generate an HTML file detailing your deployment topology, which is saved in the EPM_ORACLE_INSTANCE/diagnostics/reports directory. In modern Oracle EPM 11.2 […]

How to generate EPM Deployment Report Read More »

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 »

Scroll to Top