When a database is originally created with the Global Database Name <database>, its db_name and db_unique_name are the same. The CRS (Cluster Ready Services) database resource is named as ora.<database>.db. Changing the db_unique_name involves a complete database restart and requires careful coordination of steps. Step 1: Remove the Database, Instance, and Service Resources from CRS […]
Sequences are a fundamental feature in Oracle databases, commonly used for generating unique identifiers such as primary keys. However, in a Real Application Clusters (RAC) environment, sequence behavior introduces certain performance and ordering challenges that require careful configuration. This blog provides insights into sequence configurations, gaps, and their performance impact in a RAC setup. 1. […]
A Far Sync instance in Oracle Data Guard acts as a SYNC redo transport destination that facilitates zero data loss across long distances. By strategically placing the Far Sync instance at a metro distance from the primary database, it handles communication with a remote standby database located farther away. This setup ensures zero data loss […]
An SQL Profile in Oracle is a set of optimizer directives created to improve the execution plan for a specific SQL statement. It contains statistical information or corrections to cardinality and cost estimates, allowing the optimizer to generate a more efficient plan without changing the SQL code itself. SQL Profiles are typically generated by the […]