Running Autoconfig Parallel On Multiple Nodes
The “Parallel Run” feature enables AutoConfig to be executed simultaneously across multiple nodes of an Oracle E-Business Suite instance. Certain AutoConfig configurations of one node depend on [...]
Performance Tuning Using Active Session History
Diagnosing performance issues in old sessions is easy with an Oracle Database feature called Active Session History. Every second, Active Session History polls the database to identify the active [...]
How to Read an Execution Plan
What Is an Execution Plan? When you send a query to the database, it’s the job of the SQL optimizer to figure out how to execute it, and that process creates the query’s execution plan. The plan [...]
Faster way to Delete Lakhs of Rows from a Oracle Table
Deleting lots of rows can be slow. And there’s a chance it’ll take even longer because another session has locked the data you want to remove. We can do this by changing DML [...]
Purging SM/OPTSTAT component in SYSAUX Tablespace
Issue Description. The SYSAUX tablespace is growing continuously and SM/OPTSTAT component occupies users more that 95% of the space.This can be identified by the below query. SET LINESIZE 130 COL [...]
Enabling WF_JAVA_DEFERRED Queue
Issue All the Autoinvoice Programs are failing with error in 11.5.10.2 Instance. Changes Performed OATM migration using the OATM script Solution Perform the Below steps and enable the Queue [...]