Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle TimesTen In-Memory Database for Exalytics

( Duration: 3 Days )

This Oracle TimesTen In-Memory Database for Exalytics training course provides 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.

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 will gain valuable insight into how TimesTen works, along with the best practices for achieving optimal query performance.

By attending Oracle TimesTen In-Memory Database for Exalytics workshop, delegates will learn to:

  • 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

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

1

Introduction and Course Overview

2

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
3

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
4

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
5

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
6

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
7

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
8

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
9

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
10

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
11

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
12

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
13

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
14

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
15

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X