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