Oracle数据库优化方面资料

原文链接：Oracle数据库优化方面资料

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

Oracle官方blog

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)