Oracle TimesTen 7.0

Overview

In this four day class, students gain a hands-on understanding of the Oracle TimesTen database architecture and how its components work and interact with one another. This knowledge provides students with the background they need to plan, install, configure and tune a TimesTen database. This course will provide students with the basic knowledge to proplery plan, install, configure, tune and replicate TimesTen databases.

Course Objectives

This course provides students with a working knowledge of the Oracle TimesTen 7.0.5 IMDB architecture. Students will learn how to install and administer a TimesTen data store, create an operational data store and properly manage the various elements including user and privilege management and connection configuration modes. Students will learn how to tune the database system and gain an understanding of the different types of replication topologies, schemes and their application scenarios. Students will also learn the different types of operations performed on cache groups to keep the TimesTen data store and Oracle database synchronized. The course also includes Industry “best practices” used in implementing, managing and optimizing Oracle VM across an enterprise environment. Lab work is performed on remote systems running 64-bit Oracle Enterprise Linux and Oracle Database 11g R2.

Course Agenda

  • Describe the TimesTen products and the In-Memory Database architecture
  • Install the TimesTen software
  • Configure a data source name
  • Create and access TimesTen data store elements
  • Perform backup of a data store
  • Tune the performance of data store operations
  • Configure direct and client/server data store connections
  • Configure a Cache Connect to Oracle system
  • Perform operations on cache groups to keep the TimesTen data store and Oracle database synchronized with each other
  • Define and create cache groups
  • Configure a replicated TimesTen system by defining and creating replication schemes
  • Explain how asynchronous and synchronous replication works, and the costs and benefits of each configuration

Labs

This course includes hands-on labs that are used to reinforce key concepts and help the student become familiar with Oracle TimesTen and its application.

Prerequisites

  • A working knowledge of the SQL query language
  • Software installation experience on the UNIX/LINUX platform
  • Basic UNIX/LINUX operating system navigation skills
  • Working knowledge of vi or emacs editors
  • A working knowledge of the UNIX/LINUX Korn, Borne and Bash shells
  • Basic Oracle skills, including the ability to use sqlplus to execute SQL queries and SQL in script files

Target Audience

  • Technically-oriented subject matter expert (SME) such as an Accredited Systems Engineer (ASE) who has experience and expertise in Oracle 10g/11g
  • Database Specialists such as database engineers, designers, and programmers who have experience with Oracle 10g/11g and Linux
  • Oracle certified professionals such as an Oracle DBA
  • Oracle Database consultants with experience in Oracle 10g/11g and Linux

Delivery

For more information about scheduling one of these courses, please call us at: 1 (800) 887-4513, or e-mail us at: info@perftuning.com