SQL PROFILE IN ORACLE
SQL 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
Creating 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 MoreRunning 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 the configurations of…
Read MorePerformance 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 sessions…
Read MoreHow 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…
Read MoreFaster 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…
Read MorePurging 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…
Read MoreEnabling 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 1.Connect…
Read MoreOracle Adds Cloud Data Centers in Five Countries and Sets New Goals
After 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 MoreStep by Step Converting a file system From ASM to Non-ASM in Oracle Database
Converting a file system From ASM to Non-ASM in Oracle Database We are going to Converting a file system From ASM to Non-ASM in Oracle Database Check the database version…
Read More