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…
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 MoreStep by Step Converting a file system From Non-ASM to ASM in Oracle Database
Converting a file system From Non-ASM to ASM in Oracle Database We are going to Converting a file system From Non-ASM to ASM in Oracle Database . Check the database…
Read MoreCHANGING A DATABASE NAME USING NEWID
CHANGING A DATABASE NAME USING NEWID DBNEWID is a database utility that can change the internal database identifier (DBID) and the database name (DBNAME) for an operational database. The DBNEWID…
Read MoreMATERIALIZED VIEW
DIFFERENCE BETWEEN View and Materialized View is that Views are not stored physically on the disk.View can be defined as a virtual table created as a result of the query but Materialized View is a…
Read MoreReinstating a Failed Primary Database using Dataguard Broker
Reinstating a Failed Primary Database using Dataguard Broker Details : DETAILS SOURCE TARGET IP_ADDRESS 192.168.1.44 192.168.1.37 SERVER_NAME PRIMARY STANDBY DB_VERSION 12.2.0.1 12.2.0.1 DB_NAME DELL STANDBY The Primary Database DELL is…
Read More