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