Arvind Toorpu

Blog Posts

Connecting to CDB and PDB – Oracle Database 12c

January 24, 2024

Connecting to CDB and PDB in Oracle Using Easy Connect Syntax Connecting to CDB and PDB in Oracle Using Easy Connect Syntax When a Container Database (CDB) is created in Oracle, a service is automatically created with the same name as the CDB. Similarly, when a Pluggable Database (PDB) is created within the CDB, a…
Working with Tables and Materialized Views in Oracle: A Practical Guide

August 17, 2023

“Materialized views are a powerful feature in Oracle databases that enhance performance by storing query results, making data retrieval faster and more efficient. However, one key aspect often overlooked is the need to keep these views synchronized with the base tables, especially when underlying data changes. In this guide, we’ll explore the creation and management…
Create Oracle Control file manually

June 30, 2023

When to create control files ? Create control files in situations when : 1. You have lost all your control files. 2. When you want to rename your database name (db_name); Note :although we can use utility called DBNEWID to change the DBNAME. DBNEWID can be used to change : — Only the DBID of…
Oracle Database files to be excluded in Anti-virus or any third party tools scan

June 18, 2023

Oracle Database Files to Exclude from Antivirus and Third-Party Scans Oracle Database Files to Exclude from Antivirus and Third-Party Scans Properly managing antivirus and third-party scans is critical for maintaining the stability and performance of your Oracle Database. Failing to exclude essential database files from scans can lead to file locks, I/O exceptions, and even…
QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

May 14, 2023

Finding Archive gap between PRIMARY and STANDBY A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We can simple ship the logs which are missing in the standby database from primary database by…