[OCM 12C] Tuning SQL statements

DBMS_STATS.CREATE_EXTENDED_STATS
DBMS_STATS.GATHER_TABLE_STATS

  • PARAMETER OPTIMIZER_MODE

Database SQL Tuning Guide -> 14 Influencing the Optimizer

Related posts

Leave a Comment