I was working on the R12.2 Test env and I was supposed to decrease the JVM for the oacore(delete the managed server) The procedure to increase or decrease JVM was quite simple in R12.1.X. In Oracle E-Business Suite Release 12, the oacore, oafm, forms, and forms-c4ws services were deployed as applications on OC4J instances and […]
How to delete the manage server in R12.2 Read More »
This SQL tutorial provides explanations, examples for Delete from the table in Oracle Delete from table is used in Oracle Sql to delete the rows in the table. It is a DML (Data Manipulation Language) statement. It is used to delete the subset of existing rows or all existing rows from the table. Here is
How to delete a row in oracle Read More »
What is Profile options in Oracle Apps A set of changeable options that affect the way your application runs. The profile option acts like a Global Variable in Oracle, to provide flexibility in Oracle Applications Two types of Profile options in Oracle Apps System Profile Options: It is set by the System administrator. User cannot
Oracle Apps Profile options Read More »
Sometimes we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. (1) First, take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lstselect object_name, object_type, status, ownerfrom dba_objectswhere object_name like ‘%WF_DEFERRED_TABLE_M%’;spool off (2) Now we will proceed
How to rebuild WF_DEFERRED_TABLE_M Queue Read More »
Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime. It also means we can maintain multiple copies of the same object What is Edition in Oracle? An edition is effectively a version
How Edition-Based Redefinition in Oracle Database 11gR2/12c/18c/19c works Read More »
What is Optimizer? When a query is submitted in Oracle server. optimizer attempts to generate the best execution plan for a SQL statement. The best execution plan is defined as the plan with the lowest cost among all considered candidate plans. The cost computation accounts for factors of query execution such as I/O, CPU, and
How to use oracle optimizer hints for tuning Read More »
