India: +91 406677 1418

WhatsApp no. : +919100386313

USA: +1 909 233 6006

Telegram : +15168586242

Oracle TimesTen and In-Memory Database

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