1.Connection to Oracle Autonomous Database In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog. 2. Reading a LOB in another session Martin Berger begins by saying, “Reading a LOB in…
Category: Oracle Analytics
Oracle Analytics
Read more
Multi-File Datasets vs Multi Datasets
Managing data in Oracle Analytics can be done in a variety of ways – So how do you know which is the best way? Lets looks at the options Here’s a great video showing the muti table approach So lets recap the simple file upload methods we can use to…
Deep Dive AC36 Datasets using Data Flows
Credit: 37th America’s Cup (americascup.com) The individual races for each team are available in separate files, and we saw in the previous post that the file can be imported (into Datasets) and analysed. We are also able to create calculations on the datasets: But those calculations only exist in the…
APex
Read more
Weekly Update w/c 4th March 2024
Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Oracle Analytics
Read more
Analysing Americas Cup Performance
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…
Oracle Analytics
Read more
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,…
Analytics
Read more
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…
Analytics
Read more
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 News
Read more
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…