Table of Contents

• Title and Copyright Information
• Overview of Oracle True Cache
  • About Oracle True Cache
  • Benefits of Oracle True Cache
  • How True Cache Works
  • Considerations for Using True Cache
  • Application Usage Models
  • Lock-Free Concurrency Control
• Configuring True Cache
  • Overview of the True Cache Configuration
    • Uniform Configuration
    • Partitioned Configuration
    • True Cache Configuration Process Overview
    • Best Practices for Database Application Services
    • Best Practices for Maximum Availability Architecture (MAA) with True Cache
    • Pluggable Database (PDB) Behavior and Restrictions with True Cache
  • Configuring True Cache with DBCA
    • Prerequisites
    • Creating True Cache with DBCA
    • Configuring True Cache Database Application Services with DBCA
    • Oracle DBCA Commands and Parameters for True Cache
      • configureDatabase
      • createTrueCache
  • Configuring True Cache Manually
    • Prerequisites
    • Creating True Cache Manually
      • Edit the tnsnames.ora File for True Cache and the Primary Database
      • Configure and Start the Local Listener on the True Cache Node
      • Copy the Password File or Wallet from the Primary Database to the True Cache Node
      • Prepare a PFILE for True Cache
      • Create and Start True Cache
    • Configuring True Cache Database Application Services Manually
      • Create Database Application Services on the Primary Database
      • Verify That the Database Application Services Are Created
      • Start the Database Application Services
  • Deploying True Cache for an Oracle RAC Primary Database
  • Verifying the True Cache Configuration
    • Verifying That True Cache Is Working as Expected
    • Verifying the Remote Listener Configuration
    • Verifying the True Cache and Primary Database Application Services
  • Enabling DML Redirection
• Deploying True Cache on Oracle Base Database Service
• Deploying True Cache in Containers
• Shutting Down and Starting True Cache
  • Shutting Down True Cache
  • Starting True Cache
• Monitoring True Cache
  • Monitoring True Cache with the V$TRUE_CACHE View
    • V$TRUE_CACHE Columns
  • Monitoring True Cache with the V$TRUE_CACHE_STAT View
    • V$TRUE_CACHE_STAT Columns
  • Using the Automatic Workload Repository for True Cache
  • Monitoring True Cache with Oracle Enterprise Manager
• Using Oracle True Cache in Your Applications
  • Methods for Connecting to True Cache
  • Sample Java Code Using the JDBC Thin Driver
  • Sample Java Code for Applications Using a Native Connection to the Database
  • Best Practices for Load Balancing in a Uniform Configuration
• Complementary Caching Features
  • Server-Side Result Set Cache
  • KEEP Buffer Pool
    • Overview of Using the KEEP Buffer Pool with True Cache
      • Supported Objects
      • How True Cache Works with the Primary Database Buffer Cache
    • Configuring DB_KEEP_CACHE_SIZE on True Cache
    • Assigning Objects to the KEEP Buffer Pool for True Cache
      • TRUE_CACHE_KEEP Procedure
    • Removing an Object’s KEEP Buffer Pool Assignment for True Cache
      • TRUE_CACHE_UNKEEP Procedure
    • Viewing a List of KEEP Objects on True Cache
      • V$TRUE_CACHE_KEEP Columns
  • Database Smart Flash Cache
• Deleting True Cache
  • Using DBCA to Delete True Cache
    • Cleaning Up the True Cache Services from the Primary Database
    • Deleting True Cache from the True Cache Node
  • Deleting True Cache Manually
• Deploying Oracle True Cache with Oracle Global Data Services
  • Global Data Services Overview
  • True Cache Integration with Global Data Services
  • True Cache Implementation with Global Data Services
    • Configuring True Cache for High Availability (Failover to Read-Write)
    • Using True Cache for Read Offloading and Write Redirection
    • Using True Cache for a Singleton Read-Only Service
    • Configuring True Cache as a Reader Farm (Read-Only)
  • Configuring Global Data Services for True Cache
    • Set Up the Environment
    • Install the Global Service Manager Software
    • Configure True Cache
    • Configure the GDS Catalog Database
    • Create the GDS Catalog
    • Set Up Global Service Managers
    • (Optional) Set Up Regions
    • Set Up the GDS Pool
    • Set Up Global Services
      • Global Service Best Practices for JDBC
      • GDSCTL add service Options
    • Set Up the Client TNS Entry
  • True Cache Restrictions with Oracle Global Data Services
• True Cache Error Messages
• True Cache Database Statistics Descriptions
• True Cache Wait Events
• Licensing for True Cache
• Troubleshooting True Cache
  • Rerunning DBCA
    • Rerunning DBCA After Creating True Cache
    • Rerunning DBCA After Configuring True Cache Database Application Services
  • Preventing SRVCTL from Restarting True Cache Services for Oracle RAC Primary Databases