Database Tuning OverviewPrinciple 1: The Principle of Best BenefitPrinciple 2: Trust, but Verify Tuning ChangesPrinciple 3: Review Previous Tuning Changes When a New Change Is IntroducedEnterpriseOne Load ProfilesInteractive UsersBatch ProcessesAspects of Database Performance TuningTuning After the DesignUsing Metric StatisticsPerformance Tuning Diagnostic ChecklistTuning the Operating SystemTuning the EnterpriseOne ApplicationAnalysis Tools for the EnterpriseOne ApplicationTuning the EnterpriseOne Product Life CycleEnterpriseOne SQL Statement TuningTuning the Oracle Database InstanceThe Oracle Database Time ModelDB Time and DB Processor Time RatiosDynamic Performance ViewsOracle WAIT EventsOracle Alert LogUser Trace FilesOracle Database Monitoring and Tuning ToolsOracle Enterprise Manager (OEM)Tuning Other Oracle ResourcesOracle Full Table Scans and SQL JoinsOracle Automated Management ConfigurationsShared Pool Performance IssuesOracle Database Buffer Cache Performance IssuesProgram Global Area Memory and Temporary SpaceOracle Database Performance and Disk ArchitectureReview the LogsSufficient Swap SpaceOperating System PatchesInterprocess Communication Kernel Memory SettingsProcessor, Memory, and Disk ConfigurationConclusion