Oracle ADW statistics Tips
Database’s statistics are maintained during direct path load.
Here are the sample test.
Oracle ADW Connect Tips
Use SQLcl to connect ADW in OCI Linux 7.
Oracle 19c SQL - Real-time SQL Monitoring for Developers Tips
The real-time SQL monitoring is a 11g new feature that enables DBAs to monitor the performance of SQL statements while they are executing.
Starting in Oracle Database 19c,Oracle allow database user to view their own Real Time SQL Monitoring reports without requiring DBA privileges or SELECT_CATALOG_ROLE.
Oracle 19c SQL - Compare Plan Tips
Oracle 19c SQL - HINT_REPORT Tips
Oracle 19c dbms_xplan has an important enhancement as it can report hint usage, at least for optimizer hints.
By default, DBMS_XPLAN in the default TYPICAL format will report only invalid hints