Transportable Tablespaces (TTS) is a powerful Oracle feature that allows you to move entire tablespaces (or sets of tablespaces) between databases by physically copying datafiles plus minimal metadata, instead of unloading and reloading all the data. Because you’re moving data files rather than rows, TTS operations can be vastly faster than conventional export/import. In this […]
Oracle Data Pump (expdp / impdp) is the go-to tool for logical exports and imports. With Oracle Database 19c, Data Pump got several new enhancements to improve flexibility, performance, and security. These changes are especially useful in cloud migrations, partitioned environments, and multi-tenant databases. In this article, we’ll go through each enhancement, explain what it […]
Understanding how two different execution plans differ is a critical skill for performance tuning. In Oracle 19c and 21c, the DBMS_XPLAN package has evolved to include built-in functions that let you compare plans directly: COMPARE_PLANS, COMPARE_CURSOR, and COMPARE_EXPLAIN. In this post, we will: Environment Setup First, create a test user and a simple table to […]
In Oracle Database 19c, a powerful new feature arrives: Real-Time Statistics. Its main goal is to reduce the chance that the optimizer makes poor decisions because of stale statistics — especially in scenarios where data changes rapidly between scheduled statistics gathering cycles. Real-time statistics build on earlier features like online statistics gathering for bulk loads […]