Wednesday Oct 15, 2014

Question) Can we use TimesTen DB in Flash drive without loading into RAM in Exalytics ?

Answer) No. TimesTen is a pure in-memory database.It has to be loaded in RAM to be used. Disk/flash storage is used purely for persistence and recoverability.Hence it is not possible to access data that is not loaded into memory.

Sunday Nov 10, 2013

If
you are running Oracle BI on an Exalytics machine, you can use Summary
Advisor to identify the aggregates that will increase query performance.
Summary Advisor intelligently recommends an optimal list of aggregate
tables based on query patterns that will achieve maximum query
performance gain while meeting specific resource constraints. Summary
Advisor then generates an aggregate creation script that can be run to
create the recommended aggregate tables. Aggregate tables reduce query
times by storing precomputed results for queries that include rolled-up
data. This tutorial covers steps to set up, configure, and run Summary
Advisor on an Exalytics machine using TimesTen database as a target for
storing aggregates.

You can find the Oracle By Example (OBE) in the Oracle Learning Library(OLL). The content in OLL is available to all customers, partners, and employees.

Thursday Oct 24, 2013

You can change the properties of a dashboard and its pages. Specifically, you can:

Change the style and description of the dashboard

Add hidden named prompts to the dashboard and to its pages

Specify which links (Analyze, Edit, Refresh, Print, Export, Add to Briefing Book, and Copy)
are to be included with analyses at the dashboard level. Note that you
can set these links at the dashboard page level and the analysis level,
which override the links that you set at the dashboard level.

Rename, hide, reorder, set permissions for, and delete pages.

Specify which accounts can save shared customizations and which
accounts can assign default customizations for pages, and set account
permissions.

Specify whether the Add to Briefing Book option is to be included in the Page Options menu for pages.

Thursday Oct 17, 2013

Question:

OBI
already has a caching mechanism in presentation layer and BI server
layer. How is the new in-memory caching better for performance?

Answer:

OBI Caching only speeds up what has been seen before. An In-memory
data structure generated by the summary advisor is optimized to provide
maximum value by accounting for the expected broad usage and drilldowns.
It is possible to adapt the in-memory data to seasonality by running
the summary advisor on specific workloads. Moreover, the in-memory data
is created in an analytic database providing maximum performance for the
large amount of memory available.

Wednesday Sep 18, 2013

A:RTD is not currently planned to be certified for Exalytics. The
Exalytics architecture is not ideal for RTD (RTD requires more
processors than memory), and there are no existing or planned
optimizations to run RTD on Exalytics.