Sumário Itens Encontrados: 348Technical ReviewersChapter 1: Battle Against Any GuessGuess HuntingWhy Do We Guess?.Understanding a ProblemLogical Conclusions vs. Historical ObservationsKnowledge Is PowerRTFMFacing the Unknown.Paradigm ShiftsExperience Is Danger.Fixing the Root Cause?.Best Practices and Myths.BattleAgainstAnyGuess.comChapter 2: A Partly Cloudy FutureWhat Is Cloud Computing?Software as a Service (SAAS).Platform as a Service (PAAS).Infrastructure as a Service (IAAS).Who Are the Cloud Providers?SunSalesforce.com.Google.MicrosoftAmazon.com.Running Oracle on Amazonâs Cloud.But Is It Supported?.Making the Cloud ConcretePrerequisitesHow Do You Work This Thing?Starting Out: Getting a Suitable Operating System RunningPersistent StorageSimple Storage Service (S3)Elastic Block Storage (EBS)EBS Performance for Oracle.Attaching and Configuring EBS StoragePersistence Approaches.Method A: Generic AMI and EBS File SystemMethod B: Custom AMIMethod C: Boot from EBSOracle Backup on EC2: The OSB Cloud Module.Chapter 3: Developing a Performance MethodologyWhat Is Performance?The Early Days.Time-Based Performance AnalysisPerformance Strategy.Design and Development.Common Design PitfallsLightweight Performance Measures.Quality AssuranceTesting for PerformanceCapturing Resource Utilization and OutlinesNew Software and UpgradesKnow Your Hardware.Verify Statistics Collection.Back Up the Optimizer StatisticsImplement Change Incrementally.Post Installation or UpgradeReactive TuningStep 1: Define the Problem.Step 2: Examine the Performance Data.Step 3: Formulate a TheoryStep 4: Implement and Verify the SolutionDiagnostic ToolsUsing and Interpreting ADDMUsing and Interpreting the ASH ReportUsing and Interpreting the AWR and Statspack Instance ReportsMeaning of Key StatisticsTime-Based Statistics% Activity and Average Active Sessions.ASH-Estimated DB timeV$OSSTAT.Wait ClassesThe OptimizerManaging StatisticsLocking StatisticsExecution Plan Stability and ProfilesChapter 4: The DBA as DesignerWhen to Get Involved in Application DesignBe ApproachableAsk for Periodic Sign-off on Design and Application MilestonesAttend Code ReviewsHold PostmortemsPartnership Between DBAs and DevelopersHold Brown Bag SessionsSit Near Each OtherBe Open to New IdeasBe on the Same SideDesign-First Methodologies vs. Agile TechniquesDesign-First ApproachAgile Software DevelopmentPros and Cons of Each MethodologySchema DesignChoose Your Datatypes CarefullyWhen Bigger Is Not BetterHeaps of TroubleFaster,Not HarderOther Design ConsiderationsMiddle Tier vs. DatabaseFlexibility,Security,SpeedThe Importance of Having IntegrityDonât Be High MaintenanceThe DBA as Database Evangelist.Reading the Documentation and Keeping CurrentKnowing,Testing,and Teaching Your Softwareâs FeaturesLearning from Your Mistakes and ExperiencesTriages and PostmortemsConstant and Iterative Knowledge SharingChapter 5: Running Oracle on WindowsArchitecture.CPU ResourcesMemoryDisk.Management.The Registry.Services.ScriptingChapter 6: Managing SQL Performance.Adopting a Performance MindsetDefining and Measuring Performance.EXPLAIN PLAN.DBMS_XPLANExtended SQL Trace DataInterpreting Performance DataCase 1: The Lack of a Good Index.Case 2: The Presence of Unidentified Data Skew.Case 3: SQL That Should Be Rewritten.Case 4: SQL That Unnecessarily Invokes PL/SQLFurther ReadingChapter 7: PL/SQL and the CBOReviewing the BasicsParsing PhaseExecution Plan PreparationUsing the Extensible Optimizer.User-Defined StatisticsUser-Defined SelectivityUser-Defined CostCreating an ExampleCreating Some Example ObjectsRunning an Example QueryGiving the CBO Better InformationUnderstanding How It WorksIndicating Default Selectivity and Default CostSpecifying Defaults (Syntax).Determining a Default Cost.Breaking the Association.Influencing the Execution PlansExample 1: Influence of the Increased CostExample 2: Influence on the Order of Operations with Default StatisticsExample 3: Influence on the Order of OperationsChapter 8: Understanding Performance Optimization MethodsBlindly Changing ParametersMonitoring and Reacting to the BCHRMonitoring Delta Values of System/Session StatsMonitoring File Activity.Monitoring the Delta Values of System/Session WaitsMonitoring CPU UtilizationCPU Load GeneratorsDetermining the CPU Run QueueDetermining CPU UtilizationSampling Performance with Low OverheadCapturing Some StatisticsDecision Tree for Quickly Interpreting the StatisticsCreating Statspack or AWR ReportsMonitoring the Delta Values for SQL StatementsExamining Execution Plans and Plan StatisticsExamining Optimizer Parameters Affecting PlansGenerating 10053 Cost-Based Optimizer Traces.Activating and Deactivating the Optimizer TraceQuery Blocks.Peeked Bind VariablesOptimizer Parameters UsedTransformationsSystem StatisticsBase Statistical InformationDynamic Sampling.Single Table Access PathGeneral PlansPlan Table.Query Block RegistryHintsThe QueryGenerating 10046 Extended Traces.Enabling a 10046 Extended TraceDisabling 10046 TracingSample Trace File Analysis with Oracle 11.1.0.7Examining Server Stack TracesGenerating a Trace File on Error.Initiating a Trace with SQL*Plus ORADEBUGOperating-System-Generated Stack TracesReviewing the Enterprise Manager ADDM FindingsExamining Network PacketsExamining Client-Side Traces.SQL*Net TracingProcess Monitor TracingSpy++ TracingInvestigating Enqueue WaitsChapter 9: Choosing a Performance Optimization Method.Decision Tree for Performance Monitoring.Performance Problems Not Yet ReportedProblems Reported by End UsersProblems Reported by IT StaffSample InvestigationsQuick CheckupProblem After Upgrading the Oracle Release VersionProblem After Upgrading the ERP VersionPerformance Optimization IssuesInefficient SQLVerify the InefficiencyCollect Additional DataVerify That the Trace File Covers Only One TestVerify That the Trace File Is Complete.Verify That the Issue Is a Database IssueDetermine Whether It Is a Parse or Execution Problem.Parse Performance Issues.Majority of Parse Time Spent on the CPUMajority of Parse Time Spent on Wait EventsHigh Execution Time or Fetch Time Issues.General Optimizer Settings and Object Statistics.Histogram Issues.Common Parameters Influencing OptimizerStatement and Physical Design Issues.Data Access Issues.Optimizer Not Using (Correct) IndexPagination (Top N) QueriesProcessing Large Result Sets.Join IssuesParallel Processing Issues.Shared Pool AbuseResolving Shared Pool AbuseGeneral Guidelines for Investigating Shared Pool Abuse.Chapter 10: Managing the Very Large DatabaseDesigning (or Retrofitting) a VLDB.Infinity Is So Impreciseâ¦PartitioningEverything Is a SegmentData Manipulation with PartitioningPartition PruningPartition ConfigurationInformation Life Cycle ManagementBackup Optimization and Guaranteed RecoveryFurther Notes on StorageLimits of Which to Be AwareDatabase Block SizeNumber of Files in a DatabaseStorage That Can Migrate.Parameter READ_ONLY_OPEN_DELAYED.Chapter 11: StatisticsIt Canât Be Done!Subquery Anomaly.Partition EliminationLack of KnowledgeProblems with Statistics.Timing.MultinationalsBatch Jobs.Creating StatisticsOther StatsBaseline.Chapter 12: Troubleshooting Latch ContentionLatches and Why We Need ThemSolitaire,Parent,and Child LatchesOperational SpecificsImmediate Mode.Willing-to-Wait Mode.Latch-Wait Posting ModeIdentifying and Analyzing Latch ContentionStep 1: Identify Latches Causing ContentionStep 2: Review Distribution of GetsStep 3: Check the Code PathCache Buffers Chains Latch ContentionCommon Causes of CBC Latch ContentionAnalyzing CBC Latch Contention.Resolving CBC Latch ContentionShared Pool Latch ContentionStructures in the Shared PoolCommon Causes of Shared Pool Latch ContentionAnalyzing Shared pool Latch ContentionResolving Shared Pool Latch Contention.Library Cache Latch Contention.Common Causes of Library Cache Latch ContentionAnalyzing Library Cache Latch ContentionLibrary Cache Latches and MutexesResolving Library Cache Latch ContentionEnqueue Hash Chains Latch Contention.Common Causes of Enqueue Hash Chains Latch ContentionAnalyzing Enqueue Hash Chains Latch ContentionResolving Enqueue Hash Chains Latch ContentionAdvanced Help for Latch Contention ProblemsThe v$latch_parent ViewThe spin_count ParameterThe _latch_classes and _latch_class_N Parameters.The _latch_wait_posting and _enable_reliable_latch_waits ParametersChapter 13: Measuring for Robust PerformanceFinding the Red RocksUnderstanding the Properties of PerformanceResponse Time Is KeyThroughput CountsMeeting Expectations Matters.All Together Now.Tuning a Data WarehouseInitial Tuning.Repeating the AnalysisExploring What Variance Can Tell Us About a ProcessDistribution AnalysisDistribution of Elapsed Time DataVariance.The Index of DispersionWhat About Standard Deviation?.Elapsed Time Data SourcesAchieving Robust PerformanceDesigning an ExperimentUsing InstrumentationMeasuring the ResultsTolerance Ranges and Process CapabilityWhat is Too Much Variation?Measuring Variance Within Oracle Sample SetsSampling from SamplesChapter 14: User Security.Securing User AccountsUser Enumeration.Splitting the Task in TwoDealing with Oracle Database 10g and Prior.Feature AnalysisAccounts That Can Definitely Be RemovedAccounts That Definitely Have to Remain in the DatabaseAccounts to Analyze IndividuallyReduction of AccountsAccount Password StrengthCracking Passwords with a PL/SQL Password CrackerCracking Passwords with a Real Password CrackerFixing Weak PasswordsRoles and Privilege Assessment.Have Accounts Been Used?.Have Accounts Been Shared?Password ManagementAudit SettingsQuiz AnswerChapter 15: Securing Data.Identifying Key Data.Locating the Database TableDirect Table PrivilegesUnderstand the Hierarchy.Other Methods to Read DataAccess to Access.Duplicating DataGeneralizing Across the Database.Index.