Enable DDL logging in Oracle 12c

We need to enable DDL logging sometimes to track all DDL operations performed in database level.   Step 1:-Please set ENABLE_DDL_LOGGING to TRUE   Enter user-name: / as sysdba SQL> show parameter ENABLE_DDL_LOGGING; NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system set ENABLE_DDL_LOGGING=TRUE; System altered. Step 2:-Identify where the xml files of DDL logging will be […]

STATISTICS_LEVEL parameter Oracle 12c

You determine the level of statistics collection on the database by setting the value of the STATISTICS_LEVEL parameter. The values for this parameter are: • BASIC: No advisory or other statistical data is collected. You can manually set other statistic collection parameters such as TIMED_STATISTICS and DB_CACHE_ADVICE.Many of the statistics required for a performance baseline are not collected. Oracle strongly […]