1. Compatibility Issues David Fitzjarrell begins with: “Oracle can be set to use a broad range of version settings, controlled by the compatible setting. Normally upon install this is set to the current version of the database that’s been installed. There may be times, however, when a lower compatibility setting…
Category: Oracle Analytics
Analytics
Read more
April’s Best Blogs
1.Configuring Shared Global Area (SGA) in a Multitenant Database David Kurtz shared, “I have been working on a PeopleSoft Financials application that we have converted from a stand-alone database to be the only pluggable database (PDB) in an Oracle 19c container database (CDB). We have been getting ORA-4031 (unable to…
Analytics
Read more
April News
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…
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…