The Sport of Sailing has the usual types of championships; National, European, and World Championships, as well as a vast array of Regatta’s – Famous ones include Cowes and Antigua. The Championships are fought in boats that are identical, with very strict rules that boat owners must abide by. There…
Category: Oracle Analytics
My Setup
Before we can investigate tuning options and create a performant Analytics system, we need to have a set of test servers and the capability to rapidly implement a change and compare it to a known baseline. “Hardware” Options Cloud You could choose to use a cloud based setup, AWS, Azure,…
Weekly update
Neil Chandler begins this blog with, “Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort, and takes…
OAS Operating System Tuning
This post is part of the Analytics tuning series. see Analytics Performance Intro There are two major factors at the machine level that have a huge impact on the performance. Although there is some benefit from CPU core available, I find that CPU usage is not that high. Making the…
Monthly Round Up
This blog by Federico Venturin links to his article ‘Handling Fine-Grained Data Visualization Permissions in Oracle Analytics Cloud.’ It goes through: In his conclusion, he writes, “Until now, the all-or-nothing approach for handling permissions in Data Visualization posed a significant hurdle to its widespread adoption since administrators understandably preferred to…
Monthly Round Up – December 2023
Some of the best blogs I’ve read in the last month or so: This blog begins with, “I started some home lab cleanup this long weekend, and one of the first steps was to set up a separate DNS server for the lab. This is really just to make it…
Monthly Round Up
Blogs of the Month 1.How to study for 1z0-1067-23 – Oracle Cloud Infrastructure 2023 Cloud Operations Professional In this blog, Alex Zaballa gives some vital tips on what to focus on for the Oracle Cloud Infrastructure 2023 Cloud Operations Professional. He suggests you focus on: He also includes some handy…
Analytics Performance
ALL installations of Oracle Analytics require some form of performance tuning, either as part of the the initial build, or as a separate exercise. However, if you have not tuned prior to bringing users onto the system, you may find yourself responding to performance issues, and need to resolve them…
Installing Analytics Server 2023 – Windows
Install Oracle Analytics Server 2023 Release, in Windows