Oracle GoldenGate extract and replicat processes perform checkpoint operations. In case of some unexpected failure happened, the checkpoint file or database table ensures extract and replicat processes restart’s from the…
Read MoreSQL PROFILE IN ORACLE SQL profile is a collection of additional statistical information stored in the data dictionary that helps the optimizer to generate the best plan for the query.…
Read MoreCreating sqlplan Baselines Create sql tuning set ————————- begin DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => ‘&&sql_id’, DESCRIPTION => ‘SQL TUNE SET2’); END; / ——-SELECT DBMS_SQLTUNE.report_sql_monitor(type => ‘TEXT’, report_level=>’ALL’, SQL_ID=>’f2nydgpwc252s’) AS REPORT FROM DUAL; —…
Read MoreThe “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 MoreAfter a difficult start in cloud computing, Oracle, a long-term commercial software company, has launched a second-generation cloud system that manages the data centers in which customers lease capacity. According…
Read More