Oracle Exalytics Revealed

Table of contents

1. Cover 
2. Title Page
3. Copyright Page
4. Oracle Exalytics Revealed
   1. Introduction to Oracle Exalytics In-Memory Machine
      1. Oracle Exalytics In-Memory Machine Product Architecture
         1. Oracle Exalytics Hardware Components
         2. Oracle Exalytics Software Components
      2. How Does Oracle Exalytics In-Memory Machine Work?
         1. Connectivity to Source Databases, Including Oracle Exadata
         2. The Summary Advisor
         3. Analyzing Data Using Features Designed for Oracle Exalytics Systems
   2. Installing and Configuring Oracle Exalytics In-Memory Machine
      1. Installing and Initially Configuring Exalytics
      2. Post-Installation Tasks
         1. Hardening SSH Command-Line Access Using SSH Key Pairs
         2. Configuring Large Pages on the Exalytics Server
         3. Configuring the Exalytics Developer Workstation
         4. Importing Usage Tracking and Summary Statistics Tables into Your Oracle BI Repository, and Creating the Connection to the TimesTen Database Server
         5. Enabling Usage Tracking and Summary Statistics
      3. Maintaining Oracle Exalytics Using Integrated Lights-Out Management
         1. Accessing ILOM Management Functionality
         2. Performing Administration Tasks Using Integrated Lights-Out Management
   3. Creating the In-Memory Adaptive Data Mart
      1. Checking the Repository Using the Model Checker
      2. Identifying Analyses for “Before” and “After” Query Timings
         1. Selecting Test Case Analyses and Preparing nqcmd Scripts
         2. Using nqcmd to Run a Test Case and Obtaining Timings
      3. Running the Summary Advisor to Generate Aggregate Recommendations
         1. Example: Generating Aggregate Recommendations Using the Summary Advisor
      4. Implementing the Summary Advisor Recommendations
         1. Example: Running the Aggregate Creation Script Generated by the Summary Advisor
      5. Verifying the Aggregates Created Using the Summary Advisor
         1. Example: Using Oracle SQL*Developer to Verify the TimesTen Database
         2. Example: Using Oracle BI Administration to Verify Aggregates in the Repository
         3. Example: Checking the Query Log for Appropriate Use of Aggregate Sources
      6. Refreshing Aggregates, and Generating New Aggregate Recommendations
   4. Using Exalytics Features in Dashboards and Analyses
      1. Using Buttonless Prompts
         1. Example: Adding, or Removing, Apply and Reset Buttons from Prompts
      2. Using Auto-Complete, and Auto-Suggest, Prompts
         1. Example: Enabling a Prompt for Auto-Complete and Auto-Suggest
      3. Creating Trellis Views Using Microcharts and Sparkline Charts
         1. Example: Creating a Simple Trellis Chart
         2. Example: Creating an Advanced Trellis Chart
   5. And Finally…