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 the configurations of…
Read MoreDiagnosing 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 sessions…
Read MoreWhat 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…
Read MoreDeleting 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…
Read MoreIssue 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…
Read MoreIssue 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 1.Connect…
Read More