exhydra

[exhydra]

MANAGE ORACLE PLUGGABLE DATABASES IN 23AI

Step 1: Open a PDB in Hybrid Read-Only Mode Oracle 23ai introduces a new hybrid read-only mode. In this mode, common users can write to the database, but local users can only read. Connect to the root container as SYSDBAExample: connect using sqlplus / as sysdba Close the PDBCommand: ALTER PLUGGABLE DATABASE pdb_name CLOSE IMMEDIATE Open the PDB in hybrid read-only modeCommand: ALTER…

[exhydra]

From Copy Paste Chaos to Cloud Nirvana: The Hidden Superpower of Azure Parameterization

What if your Azure deployments could adapt like organismsWhat if a single template could evolve to fit any environment without rewriting a line That is not just good practice it is parameterization and it is a mindset shift The Problem Most Engineers Do Not See Too many cloud projects still rely on Hardcoded values Environment specific templates Manual edits for each…

[exhydra]

Oracle GoldenGate 23ai: The Future of Real-Time Data Integration

In the ever-evolving landscape of data management, Oracle GoldenGate 23ai emerges as a transformative force, redefining how organizations handle real-time data replication and integration. With its advanced features and capabilities, it empowers businesses to harness the full potential of their data, driving innovation and efficiency. What’s New in Oracle GoldenGate 23ai? 1. AI-Powered Data…

[exhydra]

Building a Data Pipeline in Azure with Azure Data Factory

In today’s data-driven world, moving and transforming data from various sources efficiently is key. Azure Data Factory (ADF) is a powerful cloud-based ETL (Extract, Transform, Load) service that enables data integration from many sources. In this blog post, you’ll learn on a high level on how to build an end-to-end Azure data pipeline that copies data from a source (like Azure Blob Storage) to a…

[exhydra]

Step-by-Step Process to Create a Linked Service in Azure Data Factory:

Log in to Azure Portal: Navigate to Azure Portal. Sign in with your Azure credentials. Create an Azure Data Factory Instance (if not already created): In the Azure Portal, search for Data Factory. Click on + Create to create a new Data Factory instance. Fill in the required fields such as Subscription, Resource Group, Region, and Data Factory Name. Click Review + Create and then Create…

[exhydra]

How to Create an Azure File Service: Your Step-by-Step Guide to Effortless Cloud Storage

In the era of cloud-first strategies, creating a reliable and scalable storage solution is a must for businesses of all sizes. Azure File Service is Microsoft’s fully managed file storage solution that offers cloud-based file shares accessible via the SMB protocol. It’s perfect for applications that rely on file storage or for companies looking to transition from traditional file servers to the…

[exhydra]

Shell Script to Install Multiple Databases Using DBCA Response Files

#!/bin/bash # Set Oracle environment variables export ORACLE_HOME=/u01/app/oracle/product/19c/dbhome_1 export ORACLE_BASE=/u01/app/oracle export PATH=$ORACLE_HOME/bin:$PATH export ORACLE_SID=ORCL # Default SID, will be overridden by response file # Log file to capture script output LOG_FILE="/u01/app/oracle/install_multiple_databases.log" # Define the directory containing the response…

[exhydra]

What Makes Cassandra Different?

At a high level, Cassandra is a distributed, decentralized, NoSQL database designed for handling large-scale, real-time data across distributed clusters. Unlike traditional databases with a master-slave model, Cassandra operates on a peer-to-peer architecture where every node in the cluster plays an equal role. This horizontal scalability and fault tolerance are its two core features. But what’s…

[exhydra]

100 Best Oracle Blogs and Websites in 2025

Excited to get recognized as one of the Top 100 Oracle Blogs! I would like to thank you for the readers who engage and support the content which motivates the purpose to write consistently. Happy to help DBA in their career journey.Thank you to Feedspot and Anuj

[exhydra]

Solving Oracle ENQ HW Contention: The Hidden Performance Killer

Oracle databases are designed for scalability and speed, but even the best systems can hit a bottleneck. One silent killer of performance that can severely degrade your Oracle environment is ENQ HW Contention. If your Oracle database feels sluggish or you’re seeing wait times spike, ENQ HW contention could be the reason. In this post, we’ll dive deep into what ENQ HW contention is, why it…

[exhydra]

How Azure Databricks is Revolutionizing Data Analytics & AI: A Deep Dive You Can’t Miss

Introduction: Welcome to the future of data analytics! We’re entering an age where data isn’t just about numbers; it’s about unlocking hidden insights, making faster decisions, and building AI models that truly understand the world around us. And guess what? Azure Databricks is at the forefront of this revolution. But here’s the catch: despite its incredible power, many professionals are still…

[exhydra]

Why Oracle OCI Compute is the Game-Changer Your Cloud Needs

In today’s fast-paced digital world, businesses are relying more than ever on cloud infrastructure to stay competitive, agile, and ahead of the curve. But with so many cloud providers out there, how do you choose the one that truly stands out? Enter Oracle Cloud Infrastructure (OCI) Compute – a powerhouse that’s not only changing the game but redefining how companies leverage cloud computing for…

[exhydra]

procedure to Rebuild index in oracle

https://github.com/kishan0426/my-ora-scripts/blob/main/proc_index_rebuild_parallel.sql

[exhydra]

Understanding Acknowledging the PGA Limit Wait Event in Oracle Database: What You Need to Know

In Oracle Database, performance tuning and optimization are critical tasks for DBAs, ensuring that the system runs efficiently and effectively. One of the most common performance bottlenecks that DBAs encounter is the PGA (Program Global Area) Limit Wait Event. Understanding what this wait event signifies and how to manage it can significantly enhance the performance of your Oracle Database. This…

[exhydra]

The Silent Troubleshooting of MongoDB Cluster Issues: What You Need to Know

MongoDB clusters are the backbone of modern scalable applications. From startups to enterprise solutions, it’s hard to find a system that doesn’t rely on MongoDB’s flexibility, scalability, and powerful features. However, when things go wrong in a MongoDB cluster, they often happen silently and can be tricky to identify. In this post, we’ll dive into some of the common MongoDB cluster issues,…

[exhydra]

Unlocking the Future of Search: Exploring Oracle 23AI's Vector Search Capabilities

In today’s fast-paced world, businesses and developers are constantly on the lookout for faster, smarter, and more efficient ways to access data. Oracle’s latest innovation, Oracle 23AI, is revolutionizing the search experience with its powerful Vector Search capabilities. Whether you’re dealing with large datasets, complex queries, or AI-driven recommendations, Oracle’s Vector Search has the…

[exhydra]

Why Apache Cassandra is the Future of Scalable and High-Performance Databases

In today’s digital world, data is growing exponentially, and businesses need scalable, high-performing databases to keep up. Enter Apache Cassandra — a powerful NoSQL database designed to handle massive amounts of data with ease. Whether you’re running a global e-commerce site, a social media platform, or a complex financial application, Cassandra can help you scale seamlessly while ensuring…