Term Archives

  1. >> Oracle Database Architecture: Buffer Cache >> Buffer Cache: Highlights >> Database Buffers >> Buffer Hash Table for Lookups >> Working Sets >> Buffer Cache Tuning Goals and Techniques >> Buffer Cache Performance Symptoms >> Buffer Cache Performance Solutions
  2. >> Shared Pool Architecture >> Shared Pool Operation >> The Library Cache >> Latch and Mutex >> Diagnostic Tools for Tuning the Shared Pool >> Avoiding Hard Parses >> Reducing the Cost of Soft Parses >> Sizing the Shared Pool
  3. >> Using Database Replay >> The Big Picture >> System Architecture >> Capture Considerations >> Replay Considerations: Preparation >> Replay Considerations >> Replay Options >> Replay Analysis
  4. >> Maintaining SQL Performance >> Maintaining Optimizer Statistics >> Automated Maintenance Tasks >> Statistic Gathering Options >> Setting Statistic Preferences >> Restore Statistics >> Deferred Statistics Publishing >> Automatic SQL Tuning
  5. >> Real Application Testing: Overview >> Real Application Testing: Use Cases >> SQL Performance Analyzer: Process >> Capturing the SQL Workload >> Creating a SQL Performance Analyzer Task >> SQL Performance Analyzer: Tasks >> Parameter Change >> SQL Performance Analyzer Task Page
  6. >> Functions of the Query Optimizer >> Selectivity >> Cardinality and Cost >> Changing Optimizer Behavior >> Optimizer Statistics >> Extended Statistics >> Controlling the Behavior of the Optimizer with Parameters >> Enabling Query Optimizer Features
  7. >> SQL Statement Processing Phases >> Role of the Oracle Optimizer >> Identifying Bad SQL >> Top SQL Reports >> SQL Monitoring >> What is an Execution Plan? >> Methods for Viewing Execution Plans >> Uses of Execution Plans
  8. >> What is a Service? >> Service Attributes >> Service Types >> Creating Services >> Managing Services in a Single-Instance Environment >> Where are Services Used? >> Using Services with Client Applications >> Services and Pluggable Databases
  9. >> Overview >> Use Cases >> Defining a Database Operation >> Scope of a Composite Database Operation >> Database Operation Concepts >> Identifying a Database Operation >> Enabling Monitoring of Database Operations >> Identifying, Starting, and Completing a Database Operation





Skip to toolbar
  • USA : +1-(917) 328-1140
  • UK : +44-(773) 940-0806
  • INDIA : +91-(779) 205-1814
  • KUWAIT : +965-(514) 31-431
  • DUBAI : +971-(557) 964-969
  • MALAYSIA : +91-(779) 205-1814
  • AUSTRAILIA : +91-(779) 205-1814