Live Webinar - ITIL 4 Overview - What’s New from ITIL v3 to ITIL 4

closeClose

Oracle TimesTen In-Memory Database for Exalytics

Course Details
Code: D81495GC10
Tuition (USD): $2,931.00 • Classroom (3 days)

The Oracle TimesTen In-Memory Database for Exalytics course teaches the core functionality of Oracle TimesTen In-Memory Database with emphasis on how to best use TimesTen with Oracle BIEE in the Exalytics In-Memory Machine environment. This course covers the key areas of the product that are applicable to Exalytics.

Learn To:

  • Use TimesTen core functionality for performance.
  • Understand installation, database sizing, operating system (OS) and database attributes that are relevant to TimesTen performance.
  • Configure and set up TimesTen for optimal performance and operational efficiency.
  • Make use of TimesTen native data types for optimal in-memory storage.
  • Use columnar compression to further reduce memory requirements.
  • Tune SQL Queries for fast query performance.
  • Use tools and best practices for data loading from the data warehouse to TimesTen.
  • Understand TimesTen system statistics and monitor using TimesTen Plug-in for Enterprise Manager.
  • Troubleshoot common configuration and setup mistakes.

Benefits to You

This course will benefit you as it clearly demonstrates the use of Oracle TimesTen In-Memory Database, with specific emphasis on the extensive benefits of using TimesTen in the Exalytics environment. You'll gain valuable insight into how TimesTen works, along with the best practices for achieving optimal query performance.

Skills Gained

  • Understand the Oracle TimesTen In-Memory Database core architecture and functionality
  • Configure and administer TimesTen databases
  • Understand the key concepts when using TimesTen in the Exalytics environment
  • Understand TimesTen persistence and recovery
  • Understand TimesTen database sizing and database loading
  • Run TimesTen tools to load data from the data warehouse to TimesTen
  • Understand performance tuning concepts such as data type mapping for optimal storage and in-memory columnar compression
  • Understand how to tune SQL queries and define proper indexes for optimal query performance
  • Use monitoring tools to monitor TimesTen databases
  • Use the TimesTen data management utilities
  • Identify TimesTen best practices for optimal usage and functioning of TimesTen databases
  • Examine troubleshooting techniques

Prerequisites

  • Knowledge of relational database concepts
  • Basic UNIX or MS Windows operating system commands
  • Knowledge of structural query language (SQL)
  • Basic UNIX or MS Windows operating system concepts
  • Some experience with Exalytics is helpful, but not mandatory

Course Details

Introduction and Course Overview

  • Course objectives
  • Intended audience
  • Course prerequisites
  • Agenda

Overview of Oracle TimesTen In-Memory Database for Exalytics

  • Oracle TimesTen In-Memory Database
  • In-Memory Transaction and Analytics RDBMS
  • TimesTen In-Memory Database (IMDB): A Relational Database
  • Three Deployment Options
  • Oracle Exalytics In-Memory Machine
  • Oracle Business Intelligence Enterprise Edition (OBIEE) + TimesTen IMDB
  • The Summary Aggregates Use Case
  • The Data Mart and Operational Data Store (ODS) Use Case

Getting Started with TimesTen

  • A TimesTen Instance
  • The TimesTen Instance Administrator
  • Data Source Names (DSNs)
  • Connection Attributes
  • Understanding the RAM Policy
  • Loading the Database into Memory
  • The TimesTen Main Daemon Process
  • Graceful Shutdown Is a Necessity

Understanding TimesTen Persistence and Recovery

  • The Checkpoint Files and Transaction Log Files
  • Defining the Connection Attributes for the Checkpoint Files and Transaction Log Files
  • Configuring the Size of the Transaction Log Files
  • Best Practice for the Checkpoint Files and Transaction Log Files
  • The Checkpointing Process
  • Defining the Checkpoint Settings for the Summary Aggregates Use Case
  • Defining the Checkpoint Settings for the Data Mart/ODS Use Case
  • Restarting and Recovering the Database

Sizing Your TimesTen Database

  • The TimesTen Shared Memory Segment
  • Defining the Size of the Memory Regions
  • Sizing the Permanent Memory Region
  • The ttSize Utility
  • Computing the Actual Size for a Table: Call the ttComputeTabSizes Built-in Procedure
  • Sizing the Temporary Memory Region
  • Monitoring the Size of Your Database
  • Changing the Size of the Database

Loading Data into Your TimesTen Database

  • Understanding Data Loading in the Exalytics Environment
  • The Source Database Is an Oracle Database
  • Loading Data from an Oracle Database: Prerequisites
  • The ttTableSchemaFromOraQueryGet Built-in Procedure
  • The ttLoadFromOracle Built-in Procedure
  • The ttIsql createandloadfromoraquery Command
  • The Source Database Is Not an Oracle Database: The ttBulkCp Utility
  • Additional Options for Loading Data into a TimesTen Database

Importing Tables from an Oracle Database

  • Moving Tables from an Oracle Database to a TimesTen Database
  • Performing Data Type Mapping
  • In-Memory Columnar Compression
  • Dictionary-Based Compression
  • The ttImportFromOracle Utility
  • Numeric Data Type Mapping: Conservative
  • Data Type Mapping: Aggressive
  • Compressing Columns

Analyzing and Tuning SQL Queries

  • The TimesTen Query Optimizer
  • Updating Statistics
  • Calling the ttOptUpdateStats and the ttOptEstimateStats Built-in Procedures
  • Index Choices in TimesTen
  • Sizing a Hash Index
  • The TimesTen Index Advisor
  • Index Strategies: The Summary Aggregates Use Case
  • Index Strategies: The Data Mart/ODS Use Case

Client Tools and OBIEE Connectivity

  • Overview of TimesTen Client/Server
  • Client/Server Setup and Configuration
  • Understanding Server DSNs
  • Client DSNs
  • Accessing a TimesTen Database with a Client/Server Connection
  • Connecting OBIEE and TimesTen
  • Oracle SQL Developer
  • SQL Developer Features for TimesTen on Exalytics

Operating System Settings for TimesTen Database

  • Shared Memory Segments on Linux
  • Shared Memory Kernel Parameters
  • Reviewing HugePages, SHMMAX, and SHMALL
  • HugePages for Efficient Memory Management
  • Configuring HugePages
  • Modifying the memlock Entry
  • Configuring HugePages for TimesTen
  • Solaris System Settings

Monitoring Your TimesTen Databases

  • An Overview of the Plug-in for TimesTen
  • The Plug-in for TimesTen: Home Page
  • The Plug-in for TimesTen: Performance Page
  • Reviewing Database Usage and Disk Space Availability
  • The ttStats Utility
  • The ttStats Utility: Monitor Mode
  • The ttStats Utility: Snapshot Mode
  • The ttStats Utility: Report Mode

TimesTen Utilities and Built-in Procedures

  • Overview of the TimesTen Utilities
  • The ttAdmin Utility
  • The ttBackup and ttRestore Utilities
  • The ttIsql Utility
  • The ttMigrate Utility
  • The ttSchema Utility
  • The ttXactAdmin Utility
  • TimesTen Built-in Procedures

Upgrading Your TimesTen Installation

  • The TimesTen Release Number Format
  • Upgrade Modes
  • In-Place Upgrades
  • Performing an In-Place Upgrade: Unload Databases
  • Performing an In-Place Upgrade: Run the Installer
  • Performing an In-Place Upgrade: Upgrade an Existing Instance
  • Performing an In-Place Upgrade: Reload Databases into Memory
  • Offline Upgrades

Best Practices for TimesTen in Exalytics

  • Configure the Optimal Settings for TimesTen Persistence and Recovery
  • Size your TimesTen Database Accurately
  • Manually Load Your Database into Memory
  • Map Data Types and Use In-Memory Columnar Compression
  • Load Data into Your TimesTen Database Efficiently
  • Tune Your SQL Queries for Optimal Performance
  • Configure the Operating System Settings for TimesTen Databases Correctly
  • Ensure a Graceful Shutdown of Your Database

Troubleshooting Your TimesTen Database

  • Gather Information: Run Utilities and Call Built-in Procedures
  • Identify and Resolve Common Issues
  • Database Is Not Loaded: Run the ttAdmin Utility
  • Transaction Log Files Are Accumulating: Call the ttLogHolds Built-in Procedure
  • Query Performance Is Slow
  • Database Is Hanging: Run the ttXactAdmin Utility
  • Operating Are Aborting: Adjust the TTC_Timeout Connection Attribute
  • Shared Memory Segment Is Not Created or Locked