Explore Oracle Hybrid Columnar Compression (HCC) through a hands-on lab comparing OLTP, Query, and Archive compression methods. See how each impacts load time and storage, with real SQL examples and visual charts.
Continue reading...Oracle 19c Automatic Indexing: A Hands-On Workshop (Repost!)
Revisit my popular, hands-on workshop guiding you through Oracle 19c’s Automatic Indexing! I’ll show you how to configure, observe, and implement auto indexes to effortlessly boost your database performance, even on non-engineered systems.
Continue reading...Refine Permissions with Precision: Mastering Privilege Analysis in Oracle 19c – A Revision
Learn how Oracle 19c simplifies privilege management with its built-in analysis tools, ensuring a ‘least privilege’ approach for enhanced database security. Discover how to use the DBMS_PRIVILEGE_CAPTURE package to analyze and refine user permissions
Continue reading...My Journey Through Oracle Database World and Cloud world 2025: A Dive into the Future of Data and AI – And a Fresh Start!
After 18 enriching years in the tech world, I recently took a deliberate break, a moment to reset and prepare for a fresh chapter. And what better way to kick off this new beginning than with a truly refreshing conference week, culminating in the exciting relaunch of my WordPress blog! This week , starting...
Continue reading...Seamless Transition: Converting Oracle 19c Non-CDB to Pluggable Database (PDB)
Unlock the power of Oracle 19c’s multitenant architecture by converting your existing non-CDB databases into pluggable databases (PDBs). This guide walks you through the essential steps, from preparing your old database to validating its compatibility and addressing post-conversion tasks.
Continue reading...The Simple, Reliable Way to Back Up Your WordPress Blog: A DIY Script for Peace of Mind
Struggling with WordPress backups? Learn how to set up an automated, custom shell script for reliable site and database protection, right from your server’s CLI.
Continue reading...Cleared 1Z0-997 Oracle Cloud Infra. Certified Architect Professional…
Cleared following 3 Oracle Cloud Infrastructure exams in a row in three days. Thanks to great Oracle COVID offers. wish to attempt more exams but could not find more slots serially.. Oracle Cloud Infrastructure 2019 Certified Architect Professional https://www.youracclaim.com/badges/ba7f88e4-25a4-4b2e-92af-dd4c6dd081f1/public_url Oracle Autonomous Database Cloud 2019 Certified Specialist. https://www.youracclaim.com/badges/787ba425-6a23-495c-a2f3-ab6082f026fe/public_urlOracle Cloud Infrastructure 2019 Architect Associate https://www.youracclaim.com/badges/2b87f825-d1b8-4746-8745-40975ca49d7f/public_url Though...
Continue reading...How to Clean up ODA Failed Deployment.
CLEANING UP FAILED ODA DEPLOYMENT. You can find cleanup.pl under /opt/oracle/oak/onecmd location. Repeat the steps on both ODA nodes.
Continue reading...ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0
ODA Bundle Patch: Upgrade to OAK 18.3.0.0.0 Here i am upgrading ODA from 12.1.2.12.0 to 18.3.0.0.0.Backup ODA_BASE before proceeding with ODA Bundle patch.For ODA_BASE backup refer to post “Backup ODA_BASE: Database Appliance ODA X5“.Above post applies to ODA X5 or higher versions. Login to ODA_BASE as root user.Download & Unpack the ODA bundle patch...
Continue reading...Backup ODA_BASE: Database Appliance ODA X5
There are situations we may need to backup ODA_BASE, especially before patching ODA_BASE.This article applies only to virtual deployment of ODA.In this Article I’ve used ODA-X5-2 appliance to backup.The procedure is applicable for ODA X5 or higher versions.ODA_BASE is backed up from the DOM machines, i.e. the parent machine from where ODA_BASE was created.Login...
Continue reading...
Recent Comments