Table of Contents

• Title and Copyright Information
• Preface
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Overview of Oracle True Cache
  • 1.1 About Oracle True Cache
  • 1.2 Benefits of Oracle True Cache
  • 1.3 How True Cache Works
  • 1.4 Considerations for Using True Cache
  • 1.5 Application Usage Models
  • 1.6 Lock-Free Concurrency Control
• 2 Configuring True Cache
  • 2.1 Overview of the True Cache Configuration
    • 2.1.1 Uniform Configuration
    • 2.1.2 Partitioned Configuration
    • 2.1.3 True Cache Configuration Process Overview
    • 2.1.4 Best Practices for Database Application Services
    • 2.1.5 Best Practices for Maximum Availability Architecture (MAA) with True Cache
  • 2.2 Configuring True Cache with Oracle DBCA
    • 2.2.1 Prerequisites
    • 2.2.2 Creating True Cache with DBCA
    • 2.2.3 Configuring True Cache Database Application Services with DBCA
    • 2.2.4 Oracle DBCA Commands and Parameters for True Cache
      • 2.2.4.1 configureDatabase
      • 2.2.4.2 createTrueCache
  • 2.3 Configuring True Cache Manually
    • 2.3.1 Prerequisites
    • 2.3.2 Creating True Cache Manually
      • 2.3.2.1 Edit the tnsnames.ora File for True Cache and the Primary Database
      • 2.3.2.2 Configure and Start the Local Listener on the True Cache Node
      • 2.3.2.3 Copy the Password File or Wallet from the Primary Database to the True Cache Node
      • 2.3.2.4 Prepare a PFILE for True Cache
      • 2.3.2.5 Create and Start True Cache
    • 2.3.3 Configuring True Cache Database Application Services Manually
      • 2.3.3.1 Create Database Application Services on the Primary Database
      • 2.3.3.2 Verify That the Database Application Services Are Created
      • 2.3.3.3 Start the Database Application Services
  • 2.4 Deploying True Cache for an Oracle RAC Primary Database
  • 2.5 Verifying the True Cache Configuration
    • 2.5.1 Verifying That True Cache Is Working as Expected
    • 2.5.2 Verifying the Remote Listener Configuration
    • 2.5.3 Verifying the True Cache and Primary Database Application Services
  • 2.6 Enabling DML Redirection
• 3 Deploying True Cache in Containers
• 4 Shutting Down and Starting True Cache
  • 4.1 Shutting Down True Cache
  • 4.2 Starting True Cache
• 5 Monitoring True Cache
  • 5.1 Monitoring True Cache with the V$TRUE_CACHE View
    • 5.1.1 V$TRUE_CACHE Columns
  • 5.2 Using the Automatic Workload Repository for True Cache
• 6 Using Oracle True Cache in Your Applications
  • 6.1 Methods for Connecting to True Cache
  • 6.2 Sample Java Code Using the JDBC Thin Driver
  • 6.3 Sample Java Code for Applications Using a Native Connection to the Database
  • 6.4 Best Practices for Load Balancing in a Uniform Configuration
• 7 Complementary Caching Features
  • 7.1 Server-Side Result Set Cache
  • 7.2 KEEP Buffer Pool
    • 7.2.1 Overview of Using the KEEP Buffer Pool with True Cache
      • 7.2.1.1 How True Cache Works with the Primary Database Buffer Cache
    • 7.2.2 Configuring DB_KEEP_CACHE_SIZE on True Cache
    • 7.2.3 Assigning Objects to the KEEP Buffer Pool for True Cache
      • 7.2.3.1 TRUE_CACHE_KEEP Procedure
    • 7.2.4 Removing an Object's KEEP Buffer Pool Assignment for True Cache
      • 7.2.4.1 TRUE_CACHE_UNKEEP Procedure
    • 7.2.5 Viewing a List of KEEP Objects on True Cache
      • 7.2.5.1 V$TRUE_CACHE_KEEP Columns
  • 7.3 Database Smart Flash Cache
• 8 Deleting True Cache
  • 8.1 Using Oracle DBCA to Delete True Cache
    • 8.1.1 Cleaning Up the True Cache Services from the Primary Database
    • 8.1.2 Deleting True Cache from the True Cache Node
  • 8.2 Deleting True Cache Manually
• A True Cache Error Messages
• B True Cache Database Statistics Descriptions
• C True Cache Wait Events
• D Licensing for True Cache
• E Troubleshooting True Cache
  • E.1 Rerunning Oracle DBCA
    • E.1.1 Rerunning Oracle DBCA After Creating True Cache
    • E.1.2 Rerunning Oracle DBCA After Configuring True Cache Database Application Services