[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

2 Thoughts to “[OCM 12C] Tuning SQL statements”

  1. … [Trackback]

    […] Find More on on that Topic: techdatabasket.com/2019/03/21/ocm-12c-tuning-sql-statements/ […]

  2. … [Trackback]

    […] Find More Info here to that Topic: techdatabasket.com/2019/03/21/ocm-12c-tuning-sql-statements/ […]

Leave a Comment