Tuning ontwerp: Server, OLTP, DSS. Hardware/Software (Unix, W2000)Een goede database configuratie: applicatie partitioning, sga, data filesTroubleshooting tools: statistics, utlbstat % utlestat utllities, oem performance managerShared pool library cache en Ddms_shared_pool() packageShared pool tuning: dictionary cache, pga/ugaTuning the buffer cache: IRU, Multiple buffer P_FFE, SGATuning data files, I/O en sortsConfiguring & tuning undo space: create database. Dba undo en Rollback segmentsSQL tuning: Optimizer, Analyze, Explain plan, Tkprof, Autorace, HistogramsPctfree/pctused, Bitmap indexesTuning Redo Iog I/O, redo log files, log_bufferContention & locks: Shared server, Parallel execution, Locks, dbms_repair() packageResumable space allocation, User_resumable view description, Special featuresOEM diagnostics pack: Capacity planner, Lock monitorOEM diagnostics pack: MA_Form – OV_Forma, Top sessionsOptie: Oracle trace en oracle trace data viewerOptie: OEM tuning pack: Tablespace manager, SQL analyze, Oracle expert