Oracle TimesTen and In-Memory Database Course Content
Introduction & Course Overview
- Describe course objectives
- Intended audience & course prerequisites
Overview of Oracle TimesTen In Memory Database
- List of features of Oracle TimesTen In Memory Database
- List of features of Oracle In Memory Database Cache
Getting Started with TimesTen In Memory Database
- Access TimesTen Quick Start & the documentation library
- Describe the concept of an instance & the instance administrator user associated with installing TimesTen
- Create a data source name & set its attributes
- Use the ttIsql command line interface utility & the Oracle SQL Developer graphical user interface tool to create or connect to a TimesTen database
Creating & Accessing TimesTen Database Elements
- Execute the SQL data definition language statements to create TimesTen supported database elements
- Explain the concept of access control & define users & assign privileges
- List & describe the different types of TimesTen indexes
- Execute SQL data manipulation language statements to access tables, sequences, views & synonyms
- Create & execute PL/SQL functions, stored procedures & packages
Managing TimesTen Databases
- Use the various utilities to import & export data into & out of a TimesTen database’s table & backup & 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 & Performance Tuning
- Explain how transactions are started & completed
- Explain how isolation levels coordinate concurrent transactions on a TimesTen database
- Use the ttXactAdmin utility to view locks requested & acquired by active transactions
- Prepare & execute statements including parameterized statements
- Update column & table statistics used by the query optimizer to generate an optimal execution plan
- Create the indexes to improve query performance
- Display a query execution plan
Configuring the TimesTen Client/Server Connections
- Describing 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 & connections from client applications
Overview of Oracle In Memory Database Cache
- List & 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 & benefits of a cache grid
- Describe the role of the cache agent & 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 & refresh a cache group
- Create a dynamic cache group & perform dynamic load operation
- Configure an automatic data aging policy on a cache group
- Create a global cache group & understand how data is shared b/w cache grid members
Other Cache Group Operations & Topics
- Create a cache group with multiple tables
- Create the 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 & 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 & describe its role
- Configure replication on a system with multiple network interface cards
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 & describe its role
- Configure replication on a system with multiple network interface cards
- List & describe the different replication states
- Configure a transaction log file threshold
- Recover a replicated database after a failure
- Use various utility commands & built-in procedures to monitor replication
Using Oracle Clusterware with TimesTen to Provide a High Availability Solution
- Describing benefits of using Oracle Clusterware with TimesTen
- Describing two different levels of availability that Oracle Clusterware can be implemented for TimesTen
- Configuring the cluster for a TimesTen active standby pair
- Create a configuration to implement application failover
- Describing how to recover from failure of one or both master database nodes