Author's posts
Oct 07 2020
Rebuilding Indexes on Oracle Database
Indexing helps to improve performance for databases query. And most of the DBA believe that rebuilding indexes also help to increase the performance and they are rebuilding indexes at a regular period of time. But most of the cases this is not true and very rare case index rebuild is required or helped on performance.
Oct 06 2020
Manually Upgrade Oracle Database from 11gR2 to 12cR2
This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.
Oct 04 2020
Manual Upgrades to Non-CDB Oracle Database
This article provides an oracle important documents list for any versions which will help you to upgrade your database to any version. Upgrade Oracle Database to 12.1: Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) (Doc ID 1503653.1)
Oct 04 2020
Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA
This article provides an overview of upgrading an existing non-CDB database from Oracle 11.2.0.4 to Oracle 12.2.0.1. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment.
Oct 02 2020
Oracle Database Upgrade Manually from 12.1 to 19.3
This article provides an overview of upgrading an existing non-CDB database from Oracle 12c to Oracle 19c. Upgrades can be very complicated, so this is highly recommended to read the oracle provided manual and test thoroughly before considering an upgrade of a production environment. Oracle Database Upgradation Manual – Read More. Upgrade Path for Oracle …
Oct 02 2020
Upgrade Oracle Enterprise Linux (OEL) 6 to OEL 7
In this article, we will discuss how can upgrade Oracle Linux from 6 to 7 on VM. We are planning to upgrade Oracle Database 12.1.0.2 to 19c. Database server’s OS is OEL 6.8 but oracle database 19c is not certified on OEL 6.8. So need to upgrade OS from version 6.8 to 7.6.
Sep 27 2020
How Oracle Database Processes DML Internally
Result set rows can be fetched either a row at a time or in groups. In the fetch stage, the database selects rows and, if requested by the query, orders the rows. Each successive fetch retrieves another row of the result until the last row has been fetched. DML-Operation. Insert a Record into a Table. …
Sep 26 2020
How Oracle Database Process Select Query Internally
This topic will describe how Oracle works internally with Index and Full Table Scan. Full Table Scan (No Index) when all blocks are available in Buffer Cache. Full Table Scan (No Index) when Blocks are not available in Buffer Cache. Select query Using index when get block from index and table segments. Select query Using …
Sep 19 2020
V$ View & Data Dictionary View on Oracle
Dynamic Performance (V$) Views: The Oracle Server contains a set of underlying views that are maintained by the server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance. Data Dictionary View: …
Sep 19 2020
Oracle Real Application Cluster (RAC) Important Components
In this topic, I will demonstrate Oracle RAC components. SCAN IP VIP IP SCAN Listener Cache Fusion Cluster Interconnect RAC 2-way Global Cache Transfer RAC 3-way Global Cache Transfer Cache Coherency Global Cache Services (GCS) Global Resource Directory (GRD) Global Enqueue Services (GES)