Optimizer plan change management: Improved stability and performance in oracle 11g

Proceedings of the VLDB Endowment

Volumn 1, Issue 2, 2008, Pages 1346-1355

  Ziauddin, Mohamed ^a   Das, Dinesh ^a   Su, Hong ^a   Zhu, Yali ^a   Yagoub, Khaled ^a  

^a ORACLE CORPORATION   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

SYSTEM STABILITY;

BUSINESS APPLICATIONS; CHANGE MANAGEMENT; CONFIGURATION PARAMETERS; GRAPHICAL INTERFACE; HARDWARE RESOURCE UTILIZATION; INDUSTRIAL STRENGTH; OPTIMAL PERFORMANCE; SOFTWARE UPGRADES;

QUERY PROCESSING;

EID: 84867116837     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/1454159.1454175     Document Type: Article

References (19)

1. Antoshenkov, G. Dynamic optimization of index scan restricted by Booleans, ICDE, 1996, pages 430-440.
2. Antoshenkov, G. and Ziauddin, M. Processing and optimization in Oracle Rdb, VLDB Journal, 1996, volume 5, number 4, pages 229-237.
3. Chakkappen, S., Cruanes, T., Dageville, B., Jiang, L., Shaft, U., Su, H. and Zait, M. Efficient and Scalable Statistics Gathering for Large Databases in Oracle llg, SIGMOD, 2008, pages 1053-1063.
4. Chen, K. Influence query optimization with optimization profiles and statistical views in DB2 9, 2006, http://www.ibm.com/developerworks/db2/librarv/techarticle/dm-0612chen/index.html
5. Dageville, B., Das, D., Dias, K., Yagoub, K., Zaït, M. and Ziauddin, M. Automatic SQL tuning in Oracle lOg, VLDB, 2004, pages 1098-1109.
6. Graefe, G. and Cole, R. Optimization of dynamic query evaluation plans, SIGMOD, 1994, pages 150-160.
7. Ioannidis, Y., Ng, R. T., Shim, K. and Sellis, T. Parametric query optimization. VLDB, 1992, pages 103-114.
8. Ives, Z. Efficient query processing for data integration, Ph.D. thesis, University of Washington, 2002.
9. Kabra, N. and Dewitt, D. Efficient mid-query reoptimization of sub-optimal query execution plans, SIGMOD, 1998, pages 106-117.
10. Markl, V., Lohman, G. M. and Raman, V. LEO: An autonomic query optimizer for DB2, IBM Systems Journal, volume 42, number 1, 2003, pages 98-106.
11. Markl, V. and Lohman, G. M. Learning table access cardinalities with LEO, SIGMOD, 2002, pages 613.
12. Markl, V., Raman, V., Simmen, D. E., Lohman, G. M. and Pirahesh, H. Robust query processing through progressive optimization, SIGMOD, 2004, pages 659-670.
13. Mcrosoft, Hints (Transact-SQL), SQL Server 2005 Books Online, 2007, http://msdn2.microsoft.com/en-us/library/msl87713.aspx
14. Oracle, Using Plan Stability, Oracle Performance Tuning Guide, Oracle Database, llg Release 1 (11.1) Documentation, Chapter 18, 2007.
15. Patel, B. A., Forcing query plans, Microsoft TechNet, 2005, http://www.microsoft.com/technet/prodtechnol/sql/2005/frcqupln.mspx
16. Qiao, L., Soetarman, B., Fuh, G., Pannu, A., Cui, B., Beavin T. and Kyu, W. A framework for enforcing application policies in database systems, SIGMOD, 2007, pages 981-992
17. Stillger, M., Lohman, G., Markl, V. and Kandil, M. LEO-DB2's learning optimizer, VLDB, 2001, pages 19-28
18. Urhan, T., Franklin, M.J. and Amsaleg, L. Cost-based query scrambling for initial delays, SIGMOD, 1998, pages 130-141.
19. Yagoub, K., Belknap, P., Dageville, B., Dias, K., Joshi, S. and Yu, H. Oracle's SQL performance analyzer. IEEE Data Engineering Bulletin, 2008, volume 31, number 1.