Using supplemental utl_file_dir in EBS Release 12 with 19c database

The Oracle E-Business suite uses OS level directories for PL/Sql File I/O for many different tasks such as generating temporary files, debugging files, log and output files etc. This PL/Sql File I/O is generally done using utl_file or fnd_file packages. However, starting with 18c version of the database, Oracle has de-supported the utl_file_dir parameter. Hence, to tackle this limitation in E-Business Suite product, Oracle introduced a supplemental utl_file_dir parameter. Oracle introduced new views apps.v$parameter and apps.v$parameter2, which provide and store this new supplemental utl_file_dir feature.

In this blog, we will review how to use this new supplemental utl_file_dir feature in EBS R12 with a 19c database.

Read More

Configure an RMAN backup of an on-prem Oracle database to OCI Object Storage

Cloud storage is popular these days because of easy accessibility, high redundancy and replication, and different storage tiering for cost-saving. With these benefits in mind, you can use cloud storage to keep OracleĀ® Database backups. Having an off-site backup copy is another good reason to take Oracle database backups on cloud storage.

Read More

Transfer SQL plans by using a SQL plan baseline

A particular SQL query might perform poorly on one database (such as production) but work fine on another database (such as development). This situation might occur if the same query has a different execution plan on each instance. This blog shows how to transfer the execution plan from an instance, where query works fine, to another instance, where query behaves poorly, by using the SQL plan baseline feature that OracleĀ® DatabaseĀ® first introduced in version 11g.

Read More

Edition Based Redefinition (EBR) and enabling an application to support EBR

Originally published by Tricore: May 5, 2017

This blog covers some basic concepts of Edition Based Redefinition (EBR) and how to use it to support an applications upgrade, which can reduce downtime.

Read More