O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Exalytics Revealed

Book Description

An in-depth Oracle Press guide to Oracle Exalytics In-Memory Machine

Written by Oracle ACE Director Mark Rittman, this e-book offers comprehensive coverage of Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform. After an overview of the product and its capabilities, you’ll get complete details on installation, configuration, administration, maintenance, and creation of the in-memory adaptive data mart that powers the “speed-of-thought” dashboards. Expert tips for integrating with both Oracle and non-Oracle enterprise data sources are included. Enable your organization to analyze large amounts of data via rich, visual dashboards using Oracle Exalytics In-Memory Machine and this Oracle Press guide.

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…