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...Saumya
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...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...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...CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address
Getting following error during CRS start. we had a server reboot post maintenance. CRS-0804, PROC-44, CRS-4535, PROC-44: Error in network address CRS-4638: Oracle High Availability Services is online CRS-4535: Cannot communicate with Cluster Ready Services CRS-4529: Cluster Synchronization Services is online CRS-4534: Cannot communicate with Event Manager [crsd(12451930)]CRS-0804:Cluster Ready Service aborted due to Oracle...
Continue reading...Oracle Database 18c, Database of Year 2018
Oracle database 18c is now available…it’s about a week since announcement made on 16 Feb. So we download a copy and try it … Well wait a sec..its released only on Oracle Cloud & Engineered Systems. So what does 18c stands for, the ‘c’ of course stands for cloud, but why 18c not 13c....
Continue reading...
Recent Comments