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
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