Consolidation of 500+ Oracle databases onto Exadata Cloud@Customer, improving performance by 2.8x and cutting costs by 40%.
Continue reading...Oracle Database
Oracle Database 9i, 10g,11g, 12c
Exploring Oracle Hybrid Columnar Compression (HCC): A Hands-On Lab with Real Results (Repost)!
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...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...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...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