Oracle SQL tuning with Oracle SQLTXPLAIN
Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge l...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
c2013.
|
| Edición: | 1st ed. 2013. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628828706719 |
Tabla de Contenidos:
- Introduction to SQLTXPLAIN
- The cost-based optimizer environment
- How object statistics can make your execution plan wrong
- How skewness can make your execution times variable
- Troubleshooting query transformations
- Forcing execution plans through profiles
- Adaptive cursor sharing
- Dynamic sampling and cardinality feedback
- Using SQLTXPLAIN with data guard physical standby databases
- Comparing execution plans
- Building good test cases
- Using XPLORE to investigate unexpected plan changes
- Trace files, TRCANLZR and modifying SQLT behavior
- Running a health check
- The final word.
