Breadcrumb

In this tutorial, you will learn how to: 1. Compile a .NET program that connects to an Oracle or TimesTen database 2. Compare the differences in application response time between running an application on a standalone Oracle database, versus an Oracle database where some of the Oracle tables are cached in a TimesTen in-memory cache database

**Note:** This tutorial applies only to the Database Application Development Virtual Machine that can be downloaded here. This tutorial shows you how to use PL/SQL with Oracle TimesTen In-Memory Database and Oracle In-Memory Database Cache. The PL/SQL engine from the Oracle Database was efficiently ported to run inside the TimesTen database in the application-tier, using the same PL/SQL language and syntax. This tutorial demonstrates how you can leverage TimesTen to enhance the performance of PL/SQL code.

**Note:** This tutorial applies only to the Database Application Development Virtual Machine that can be downloaded here. This tutorial shows you how to cache Oracle database tables using Oracle In-Memory Database Cache (IMDB Cache). IMDB Cache improves application transaction response time, by caching a performance-critical subset of tables from an Oracle database into a TimesTen in-memory database running in the application tier. This tutorial provides a step by step guide to create an In-Memory Database Cache Grid with a number of grid members to distribute the cache data on multiple nodes. The tutorial will show how to specify and create different cache groups and how to access the cache data.

In this tutorial, you will learn how to: 1. Create the TimesTen schema and cache administration user in the Oracle database 2. Set up a TimesTen database 3. Create a TimesTen database and configure it to be an in-memory cache database 4. Create a cache grid and associate the cache database with the cache grid

In this tutorial, you will learn how to: 1. Create connections to Oracle and TimesTen databases using SQL Developer 2. Create a Readonly cache group to cache Oracle database tables in TimesTen 3. Load data from an Oracle Database into a TimesTen in-memory cache database using a Readonly cache group 4. Create an Asynchronous Writethrough (AWT) cache group to cache Oracle database tables in TimesTen 5. Propagate data from a TimesTen in-memory cache database to an Oracle database using an AWT cache group

 

This tutorial shows you how to create and manage an updatable cache group in Oracle In-Memory Database Cache 7.0

This tutorial shows you how to securely access the TimesTen Cache Administrator 7.x web application remotely via a browser.