Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » 性能优化

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)


关键词:optimizer oracle 

相关文章

基于PDB的Active Data Guard(Oracle 21.7+)
在Oracle数据库中使用REST
OGG from MySQL to Oracle
Oracle数据库容灾之两地三中心实践
低代码开发用Oracle Apex,看这篇就够了
Oracle Database 20c之SQL宏
Java beginner for Oracle DBA
Oracle Database 20c之区块链表
Oracle Database 20c的一些微妙变化
关于Oracle的Sequence,你需要知道的
Oracle数据库优化方面资料
Oracle Database 19c在优化方面有哪些新特性
Top