Kursangebot
- Upcoming Events
- Neue Kurse
- Garantietermine
- Training nach Technologie
- Cloud Computing»
- Cyber Security»
- Data Center»
- Internet of Things (IoT)»
- Kubernetes / Container»
- Linux»
- Network Analysis / Wireshark»
- Projektmanagement
- Python»
- Software Development»
- Wireless & Mobility»
- Training nach Hersteller
- Aruba»
- Microsoft»
- Cisco»
- NetApp»
- VMware»
- Fortinet»
- Palo Alto Networks»
- Red Hat»
- Barracuda
- Check Point
- F5 Networks
- Ethical Hacking
- CISSP
- Amazon Web Services»
- Google Cloud»
- IT-Training by iTLS
- ITIL® und Cobit
- Citrix»
- Pivotal / Spring»
- Kaspersky Lab
- Symantec»
- Oracle»
- Brocade
- Juniper
- IBM
- Veritas
D73549
Online Training
Dauer 3 Tage
Preis (exkl. MwSt.)
- 1.893,- €
Sprache der Kursunterlagen: Englisch
Derzeit gibt es keine Online-Termine für diesen Kurs.
Classroom Training
Dauer 3 Tage
Preis (exkl. MwSt.)
- Österreich: 2.010,- €
- Schweiz: CHF 2.484,-
Sprache der Kursunterlagen: Englisch
Derzeit gibt es keine Klassenraum-Termine für diesen Kurs.
Termin anfragenOracle SQL Tuning for Developers Workshop (D73549)
Detaillierter Kursinhalt
Introduction
Introduction to SQL Tuning
- Find a workaround to enhance performance
- Analyze a poorly written SQL statement
- Create a function based index
- Redesign a simple table
- Rewrite the SQL statement
Using SQL Trace Facility and TKPROF
- Explore a trace file to understand the optimizer’s decisions
Understand Basic Tuning Techniques
- Rewrite queries for better performance
- Rewrite applications for better performance
- Utilize SQL Tuning Advisor using SQL Developer 3.0
Optomizer Fundamentals
- Explore a trace file to understand the optimizer’s decisions
Understanding Serial Execution Plans
- Use different techniques to extract execution plans
- Use SQL monitoring
Optimizer: Table and Index Access Paths
- Learn about using different access paths for better optimization
Optimizer: Join Operations
- Use different access paths for better optimization
- Examine and use the result cache
Other Optimizer Methods
- Use different access paths for better optimization
- Examine and use the result cache
Optimizer Statistics
- Analyze and use system statistics
- Use automatic statistics gathering
Using Bind Variables
- Use adaptive cursor sharing and bind peeking
- Use the CURSOR_SHARING initialization parameter
SQL Plan Management
- Use SQL Plan Management