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...May 2025
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...
Recent Comments