Oracle 11g : SQL Tuning
Une serie de plusieurs documents décrivant comment identifier les problèmes de performances (V$, statpacks, AWR Diag Pack...), comment vérifier les hypothèses, déterminer ce qui ne va pas et le corriger. Tout ceci autour d'un thème important pour les performances de la base de données oracle : l'optimiseur et ses statistiques
- Matière
- Bases de données
- Niveau
- Expert
- Langue
- Anglais
- Auteur(s)
- Oracle Corporation
- Origine
- Oracle (OpenWorld, notes My Oracle Support)
- Date de parution
- septembre 2005
- Format
- ZIP · 15 pages
- Taille
- 6 Mo (6 338 546 octets)
- Publié sur le site
- 15 mars 2014
Contenu de l'archive (30 fichiers)
- Session2-SQLTuning/Session2/1-Identifying SQL/232443.1-How to Identify Resource Intensive SQL for Tuning.mht
- Session2-SQLTuning/Session2/1-Identifying SQL/ash_01.sql
- Session2-SQLTuning/Session2/1-Identifying SQL/awrsnapaas_OK.sql
- Session2-SQLTuning/Session2/1-Identifying SQL/PS_S001_274001_106-1_FIN_v1.pdf
- Session2-SQLTuning/Session2/1-Identifying SQL/PS_S997_273997_106-1_FIN_v2.pdf
- Session2-SQLTuning/Session2/1-Identifying SQL/sp_46923_46994.lst.txt
- Session2-SQLTuning/Session2/2-Verifying/2.4 Annexe.RowSource Statistics_doc.pdf
- Session2-SQLTuning/Session2/2-Verifying/2.4 Annexe.RowSource Statistics_ppt.pdf
- Session2-SQLTuning/Session2/2-Verifying/376442.1-Recommended Method for Obtaining 10046 trace for Tuning.mht
- Session2-SQLTuning/Session2/2-Verifying/39817.1-Interpreting Raw SQL_TRACE and DBMS_SUPPORT.START_TRACE.mht
- Session2-SQLTuning/Session2/2-Verifying/Oracle_Operational_Timing_Data.pdf
- Session2-SQLTuning/Session2/2-Verifying/Trace(01)_fry_ora_3460.trc
- Session2-SQLTuning/Session2/2-Verifying/Trace(02)_fry_ora_3544.trc
- Session2-SQLTuning/Session2/2.1 Row Source Operation Catalog.pdf
- Session2-SQLTuning/Session2/2.1 Row Source Operation Catalog_ppt.pdf
- Session2-SQLTuning/Session2/2.1.Annexe1.Outerjoins in Oracle.doc
- Session2-SQLTuning/Session2/2.2 Find The Plan.pdf
- Session2-SQLTuning/Session2/2.2 Find The Plan_ppt.pdf
- Session2-SQLTuning/Session2/2.3 Interpret The Plan.pdf
- Session2-SQLTuning/Session2/2.3 Interpret The Plan_ppt.pdf
- Session2-SQLTuning/Session2/2.4 Annexe.Method_ppt.pdf
- Session2-SQLTuning/Session2/3-Determining What's Wrong/2009_q306_deng.pdf
- Session2-SQLTuning/Session2/3-Determining What's Wrong/338137.1-Case Study - Analyzing 10053 Trace Files trc.mht
- Session2-SQLTuning/Session2/3-Determining What's Wrong/338137.1-Case Study - Analyzing 10053 Trace Files.mht
- Session2-SQLTuning/Session2/3-Determining What's Wrong/386360.1-Simple Tuning Example Using 10046 and explain plans.mht
- Session2-SQLTuning/Session2/3-Determining What's Wrong/SQLnet_Message_from_client_-_Idle_Time_or_your_Problem.pdf
- Session2-SQLTuning/Session2/4-Fix-it/NotNullConstraintsAndExecutionPlans RealWorld TWiki.mht
- Session2-SQLTuning/Session2/Oracle Performance Diagnostic Guide/OPDG_Hang.pdf
- Session2-SQLTuning/Session2/Oracle Performance Diagnostic Guide/OPDG_Query_Tuning.pdf
- Session2-SQLTuning/Session2/Oracle Performance Diagnostic Guide/OPDG_Slow_Database.pdf