19c在优化方面的增强
https://blogs.oracle.com/optimizer/whats-new-in-the-oracle-optimizer-for-oracle-database-19c
https://blogs.oracle.com/optimizer/oracle-database-19c-and-sql-plan-management-diagnostics
应该知道的优化知识
https://blogs.oracle.com/optimizer/how-to-gather-optimizer-statistics-fast
https://blogs.oracle.com/optimizer/how-to-generate-a-useful-sql-execution-plan
https://blogs.oracle.com/optimizer/should-you-gather-system-statistics
https://blogs.oracle.com/optimizer/using-sql-plan-management-to-control-sql-execution-plans
https://blogs.oracle.com/optimizer/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-1
https://blogs.oracle.com/optimizer/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-2
https://blogs.oracle.com/optimizer/efficient-statistics-maintenance-for-partitioned-tables-using-incremental-statistics-part-3
https://blogs.oracle.com/optimizer/sql-plan-management-part-1-of-4-creating-sql-plan-baselines
https://blogs.oracle.com/optimizer/what-you-need-to-know-about-sql-plan-management-and-auto-capture
https://blogs.oracle.com/optimizer
https://blogs.oracle.com/author/nigel-bayliss
Oracle优化方面练习的脚本
https://github.com/oracle/oracle-db-examples/tree/master/optimizer
收集统计信息的最佳实践
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-optimizer-with-oracledb-19c-5324206.pdf
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-stats-concepts-19c-5324209.pdf
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-19c-5324207.pdf
https://blogs.oracle.com/optimizer/what-adaptive-feature-settings-should-you-use-in-oracle-database-12c-release-2
Reference
https://www.oracle.com/database/technologies/datawarehouse-bigdata/query-optimization.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/index.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/index.html
https://blogs.oracle.com/database4cn/
https://blogs.oracle.com/exadatacn/
https://github.com/carlos-sierra/cscripts/tree/master/sql
Master Note: SQL Query Performance Overview (Doc ID 199083.1)
Avoiding and Resolving Database Performance Related Issues After Upgrade (Doc ID 1528847.1)
Avoiding Upgrade Related Query Issues (Doc ID 167086.1)
Master Note: Plan Stability Features (Including SQL Plan Management (SPM)) (Doc ID 1359841.1)
Master Note for Real Application Testing Option (Doc ID 1464274.1)
