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.1.6 Pluggable Database (PDB) Behavior and Restrictions 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 Monitoring True Cache with the V$TRUE_CACHE_STAT View
    • 5.2.1 V$TRUE_CACHE_STAT Columns
  • 5.3 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 Supported Objects
      • 7.2.1.2 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
• 9 Deploying Oracle True Cache with Oracle Global Data Services
  • 9.1 Global Data Services Overview
  • 9.2 True Cache Integration with Global Data Services
  • 9.3 Configuring Global Data Services for True Cache
    • 9.3.1 Set Up the Environment
    • 9.3.2 Install the Global Service Manager Software
    • 9.3.3 Configure True Cache
    • 9.3.4 Configure the GDS Catalog Database
    • 9.3.5 Create the GDS Catalog
    • 9.3.6 Set Up Global Service Managers
    • 9.3.7 (Optional) Set Up Regions
    • 9.3.8 Set Up the GDS Pool
    • 9.3.9 Set Up Global Services
      • 9.3.9.1 Global Service Best Practices for JDBC
      • 9.3.9.2 GDSCTL add service Options
    • 9.3.10 Set Up the Client TNS Entry
  • 9.4 True Cache Restrictions with Oracle Global Data Services
• 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
  • E.2 Preventing SRVCTL from Restarting True Cache Services for Oracle RAC Primary Databases