CLEAN_AUDIT_TRAIL Runs Slowly ? If you have never purged the unified audit trails in your database, the first time deletion by CLEAN_AUDIT_TRAIL may take a… Read More »How to Speed Up CLEAN_AUDIT_TRAIL
Partitioned Index To align with the partitioned table we created by SQL developer previously, we can add a partitioned index for it to improve data… Read More »SQL Developer Create Index Partition
LAST_DDL_TIME Generally speaking, LAST_DDL_TIME in ALL_OBJECTS or DBA_OBJECTS means that the last time of the object definition changed by Data Definition Language (DDL). But sometimes,… Read More »LAST_DDL_TIME, How and Why