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…
Tag: Oracle Analytics
Analytics
Read more
Weekly Update – w/c February 19th
In this blog, Atul Kumar covers: 2. Using server-side JavaScript in APEX processes Martin Bach writes, “In this installment of the mini-series you will learn how to write more complex server-side logic using MLE/JavaScript ECMAScript modules.” He goes through: 3. Oracle Sharding methods compared to YugabyteDB Franck Pachot begins his blog…
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…
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…
Cloud
Read more
Monthly Round Up – October 2023
Blogs of the Week This blog centres around the new Oracle Cloud Infrastructure (OCI) Product Tours page. This is the analytics section The page also features links to useful YouTube videos. 2. Extract OCI Monitoring Metrics Using REST APIs Alfredo Krieg shares how you can list metric definitions and how…
Monthly News
Read more
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
Read more
Monthly Round Up
Blogs of the month Here’s 10 of the best from the last few weeks: 1.Enabling Search Framework Real Time Indexing (RTI) Jim Marion writes, “As we prepare our HCM PUM 46 training servers, we decided to enable Real Time Indexing (RTI). We found several great sample videos and resources but still made…
Analytics
Read more
Installing Analytics Server 2023 – Windows
Install Oracle Analytics Server 2023 Release, in Windows
Analytics
Read more
Recent Blogs and News
Blogs This blog begins with: “Today when checking a recently installed server with Oracle Linux 7.9 and ASM 19.17 with ASMLib, we found that when performing any reboot on the server, ASM could not mount the disks.” Read how the fix was applied! 2. Health Check for DB Nikhil shares…