Opleiding: Oracle Database 11g Performance Tuning

Gedurende deze training leer je technieken om performance en configuration problemen in de Oracle database op te sporen en deze op te lossen.

• Tuning ontwerp: Server, OLTP, DSS. Hardware/Software (Unix, W2000)
• Een goede database configuratie: applicatie partitioning, sga, data files
• Troubleshooting tools: statistics, utlbstat % utlestat utllities, oem performance manager
• Shared pool library cache en Ddms_shared_pool() package
• Shared pool tuning: dictionary cache, pga/uga
• Tuning the buffer cache: IRU, Multiple buffer P_FFE, SGA
• Tuning data files, I/O en sorts
• Configuring & tuning undo space: create database. Dba undo en Rollback segments
• SQL tuning: Optimizer, Analyze, Explain plan, Tkprof, Autorace, Histograms
• Pctfree/pctused, Bitmap indexes
• Tuning Redo Iog I/O, redo log files, log_buffer
• Contention & locks: Shared server, Parallel execution, Locks, dbms_repair() package
• Resumable space allocation, User_resumable view description, Special features
• OEM diagnostics pack: Capacity planner, Lock monitor
• OEM diagnostics pack: MA_Form - OV_Forma, Top sessions
• Optie: Oracle trace en oracle trace data viewer
• Optie: OEM tuning pack: Tablespace manager, SQL analyze, Oracle expert