Sumário Itens Encontrados: 315Chapter 1: MethodologyPerformance RequirementsTuning the SystemStep 1: Optimizing WorkloadStep 2: Finding and Eliminating ContentionStep 3: Reduce Physical I/OStep 4: Optimize Logical I/OMethodologyPerformance Tuning MethodologyGetting to the ObviousDivide Into QuadrantsLooking at Overall Database PerformanceOracle Unified MethodTesting and Performance ManagementRAP TestingRAP Testing Phase IâStability Testing of the ClusterRAP Testing Phase IIâAvailability and Load BalancingRAP Testing Phase IIIâHigh AvailabilityRAP Testing Phase IVâBackup and RecoveryRAP Testing Phase VâHardware ScalabilityRAP Testing Phase VIâDatabase ScalabilityRAP Testing Phase VIIâApplication ScalabilityCreating an Application Testing EnvironmentHow Much to Tune?ConclusionChapter 2: Capacity Planning and ArchitectureAnalyzing the StackCapacity PlanningHow to Measure ScalingEstimating Size of Database ObjectsArchitectureOracle Single-Instance vs. Clustered ConfigurationRAC ArchitectureChapter 3: Testing for AvailabilityPoints of Failure (Gaps)Interconnect FailureNode FailureInstance FailureOracle Component FailureMedia FailureProtecting the DatabaseTesting Hardware for AvailabilityRAP Phase ITesting Application for AvailabilityRAP Phase IIâAvailability and Load BalancingRAP Phase IIIâHARAP Phase IVâBackup and RecoveryChapter 4: Testing for ScalabilityScale-Up or Scale-OutScale-UpScale-OutScalable ComponentsInterconnectASMInstanceSQL*NetTesting Hardware for ScalabilityRAP Phase V Hardware ScalabilityTesting the Database for ScalabilityTesting Application for ScalabilityRAP Phase VII Application ScalabilityEnd-to-End TestingChapter 5: Real Application TestingTesting MethodsMethod IâUsing Homegrown UtilitiesMethod IIâUsing Real Application TestingChapter 6: Tools and UtilitiesOracle Enterprise ManagerPerformance ManagerSQL AdvisoryAutomatic Workload RepositoryAutomatic Workload Repository WarehouseAutomatic Database Diagnostic MonitorActive Session HistoryTools and Utilities from Oracle SupportOSWATCHERLight Onboard Monitor (LTOM)Cluster Health Monitor (CHM)CHM StatisticsEXPLAIN PLANDBMS_SQLTUNESQL TraceEvent 10046Level 1Level 4Level 8Level 12Event 10053Service-Module-ActionThe trcsess UtilityOracleâs Wait InterfaceChapter 7: SQL TuningSQL Execution Life CycleStep 1: Create a CursorStep 2: Parse the StatementStep 3: Describe the ResultsStep 4: Define Query OutputStep 5: Bind Any VariablesStep 6: Parallelize the StatementStep 7: Execute the StatementStep 8: Fetch RowsStep 9: Close the CursorCapturing Execution TimesTIMED_STATISTICSSTATISTICS_LEVELV$STATISTICS_LEVELTIMED_OS_STATISTICSWhat Are Consistent Gets?Logical ReadsPhysical ReadsWhy Tune?OptimizerOptimizer StatisticsChapter 8: Parallel Query TuningWhy Parallel Processing?Oracle and Parallel ProcessingParallel Query ArchitectureMethods of Applying ParallelismParallel Processing in RACParallel RecoveryOptimizing Parallel OperationsData Dictionary Views to Monitor Parallel OperationsWait Events Related to Parallel OperationsTroubleshooting Using Oracle Event InterfaceChapter 9: Tuning the DatabaseData PartitioningPartitioned IndexesLocal IndexesGlobal IndexesBenefits of PartitioningPartition PruningPartition-wise JoinsSequence NumbersSequences and Index ContentionUndo Block ConsiderationsHard ParsesResult CacheQuery Result CacheFunction Result CacheLimitations of the Result CacheIn-Memory CacheHow Does This Work?Chapter 10: Tuning RecoveryInstance RecoveryHow Does Oracle Know That Recovery Is Required for a Given Data File?The Instance Recovery ProcessTuning Instance RecoveryRedo Log Sizing AdvisoryCrash RecoveryThread RecoveryOnline Block Level RecoveryMedia RecoveryFast Recovery AreaChapter 11: Tuning Oracle NetMaking the ConnectionConnectivity DriversOracle Net Foundation Layer (ONFL)Oracle Protocol Support LayerListenersLoad BalancingTracing the Load Metric CaptureConnection ThroughputWait Events related to SQL*NetChapter 12: Tuning the Storage SubsystemChoosing StorageTransaction-Based WorkloadThroughput-Based WorkloadMixed WorkloadChoosing the Storage ArrayStorage-Wide Considerations for PerformanceDisk Drive PerformanceStorage ContentionOracle Files and RAIDDatafilesRedolog FilesTesting to Determine PerformanceTypes of I/O OperationsOracle and I/O CharacteristicsOracle-Supported Access TypesClustered File SystemAutomatic Storage ManagementASM Clustered File SystemASM ArchitectureAllocation UnitsHow Many Diskgroups?Monitoring ASMData Dictionary Views to Monitor StorageEnterprise Manager to Monitor StorageChapter 13: Tuning Global CacheGlobal CacheRAC Specific Background ProcessesLMSnLMONLMDnLCK0LMHBACMSRMSnRSMNPINGIPC0LDDnResource AvailabilityThink Outside the InterconnectScenario 1: Block Request Involving Two InstancesScenario 2: Block Request Involving Three InstancesPrepare PhaseTransfer PhaseMastering and RemasteringMonitoring RemasteringManual RemasteringGlobal Cache OptimizationQueries with High Cluster OverheadBlockers and DeadlocksIdentifying Hot BlocksData Dictionary Views to Monitor Global CacheEnterprise Manager to Monitor Global CacheChapter 14: Tuning the Cluster InterconnectCluster InterconnectBlock TransferTypes of InterconnectsNetwork Throughput and BandwidthVerifying the InterconnectCheck 1Check 2Check 3Check 4Check 5Think Inside the InterconnectLinear Scalability of Private InterconnectInterconnect MonitoringData Dictionary Views to Monitor Cluster InterconnectEnterprise Manager to Monitor Cluster InterconnectChapter 15: Optimize Distributed WorkloadService FrameworkManageabilityAvailabilityPerformanceServer PoolsDistributed Workload Management (DWM)Resource ManagerFast Application Notification (FAN)Fast Connect Failover (FCF)Client Load BalancingConnection Load BalancingApplications Using Connection PoolingLocating the ProblemChapter 16: Oracle Clusterware DiagnosisOracle ClusterwareThe Oracle Cluster Registry (OCR)The Oracle Local Registry (OLR)High Availability Service (HAS)The Cluster Synchronization Service (CSS)Cluster/Node Failures/EvictionsOCR Administration UtilitiesOCR Verification (ocrcheck) UtilityOCR Configuration (ocrconfig) UtilityOCR Dump (ocrdump) UtilityEVMD VerificationGrid Plug and PlayMonitoring Resource Utilization in the ClusterStep 1Step 2Step 3Chapter 17: Waits,Enqueues,and LatchesLatchesWilling-to-Wait ModeNo-Wait ModeCache Buffers Chainsgc elementRedo AllocationClassesEnqueuesTXâTransactionTMâDML (Table)STâSpace Management TransactionHWâSegment High Water MarkSQâSequence NumberCFâControl File TransactionWaitsConsistent Read vs. CurrentCluster WaitsMutex WaitsChapter 18: Problem DiagnosisHealth MonitorV$HM_CHECKRunning ChecksHM Using EMAutomatic Diagnostic RepositoryADR ActionsADR ConfigurationRetention PolicyWorkshopâMonitoring Incidents and ProblemsSQL Test Case BuilderORADEBUG UtilityCritical ORA ErrorsORA-600: Internal error code,arguments: [ ],[ ]ORA-7445: exception encountered core dump [ ][ ]DBA Support UtilitiesRemote Diagnostic Agent (RDA)RAC DIAGORACHKOLSAppendix A: The SQL Scripts Used in This BookChapter 3âTesting for AvailabilityChapter 4âTesting for ScalabilityChapter 6âTools and UtilitiesChapter 9âTuning the DatabaseChapter 11âTuning Oracle NetChapter 12âTuning the Storage SubsystemChapter 13âTuning Global CacheChapter 14âTuning the Cluster InterconnectChapter 15âOptimizing Distributed WorkloadChapter 17âWaits,Enqueues,and LatchesChapter 18âProblem Diagnostics