Oracle TimesTen Training Online

Oracle TimesTen and In-Memory Database Cache 11g

This Oracle TimesTen and In-Memory Database Cache 11g training teaches you about the in-memory database architecture. You'll learn how to administer a TimesTen database, while configuring and administering a TimesTen database that caches data from an Oracle database.

Duration: 25hrs

Required Prerequisites:

• Relational database concepts and SQL
• Oracle database administration
• UNIX or Microsoft Windows operating system commands and concepts

Course Content:

Introduction and Course Overview

• Describe course objectives
• Intended audience and course prerequisites

Overview of Oracle TimesTen In-Memory Database

• List the features of Oracle TimesTen In-Memory Database
• List the features of Oracle In-Memory Database Cache

Getting Started with TimesTen In-Memory Database

• Access TimesTen Quick Start and the documentation library
• Describe the concept of an instance and the instance administrator user associated with installing TimesTen
• Create a data source name and set its attributes
• Use the ttIsql command-line interface utility and the Oracle SQL Developer graphical user interface tool to create or connect to a TimesTen database

Creating and Accessing TimesTen Database Elements

• Execute SQL data definition language statements to create TimesTen supported database elements
• Explain the concept of access control, and define users and assign privileges
• List and describe the different types of TimesTen indexes
• Execute SQL data manipulation language statements to access tables, sequences, views and synonyms
• Create and execute PL/SQL functions, stored procedures and packages

Managing TimesTen Databases

• Use the various utilities to import and export data into and out of a TimesTen database’s table, and backup and restore a database
• Use the ttSize utility to estimate the size of a table
• Use the ttStatus utility to display connections on TimesTen databases
• Call the TimesTen built-in procedures
• Configure a database RAM policy
• Modify the size of a TimesTen database

Concurrency Control and Performance Tuning

• Explain how transactions are started and completed
• Explain how isolation levels coordinate concurrent transactions on a TimesTen database
• Use the ttXactAdmin utility to view locks requested and acquired by active transactions
• Prepare and execute statements including parameterized statements
• Update column and table statistics used by the query optimizer to generate an optimal execution plan
• Create indexes to improve query performance
• Display a query execution plan

Configuring TimesTen Client/Server Connections

• Describe the TimesTen client/server architecture
• Configure a client/server environment
• Access a TimesTen database with a client/server connection
• Configure the TimesTen Server to run in multithreaded mode
• Use the ttStatus utility to display information about the server process and connections from client applications

Overview of Oracle In-Memory Database Cache

• List and describe features of Oracle In-Memory Database Cache
• Describe various usages of Oracle In-Memory Database Cache

Getting Started with Oracle In-Memory Database Cache

• Configure the Oracle and TimesTen databases to cache Oracle data in the TimesTen database
• Describe the contents and benefits of a cache grid
• Describe the role of the cache agent and start the agent process

Creating Cache Groups

• Create read-only and writethrough cache groups
• Describe the automatic refresh operation
• Passthrough statements from TimesTen to Oracle for execution
• Manually load and refresh a cache group
• Create a dynamic cache group and perform dynamic load operations
• Configure an automatic data aging policy on a cache group
• Create a global cache group and understand how data is shared between cache grid members

Other Cache Group Operations and Topics

• Create a cache group with multiple tables
• Create user-managed cache groups
• Flush a user-managed cache group
• Use SQL Developer to perform cache group operations

Overview of TimesTen to TimesTen Replication

• Describe the benefits of TimesTen to TimesTen replication
• Describe the active standby pair replication configuration
• Describe the basic architecture of TimesTen replication
• Describe the differences between asynchronous and synchronous replication

Configuring Replication of TimesTen Databases

• Create an active standby pair replication scheme
• Create a return two-safe synchronous replication scheme
• Configure replication of cache tables
• Start the replication agent process and describe its role
• Configure replication on a system with multiple network interface cards

Database Recovery and Monitoring Replication

• List and describe the different replication states
• Configure a transaction log file threshold
• Recover a replicated database after a failure
• Use various utility commands and built-in procedures to monitor replication

Using Oracle Clusterware with TimesTen to Provide a High Availability Solution

• Describe the benefits of using Oracle Clusterware with TimesTen
• Describe the two different levels of availability that Oracle Clusterware can be implemented for TimesTen
• Configure a cluster for a TimesTen active standby pair
• Create a configuration to implement application failover
• Describe how to recover from failure of one or both master database nodes