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…
Category: Analytics
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…
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
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…
Installing Analytics Server 2023 – Windows
Install Oracle Analytics Server 2023 Release, in Windows
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…
Pre-Christmas Blog
I’d love to take this opportunity to wish you a wonderful festive season – and all the very best for 2023. If you’ve got a few moments amongst the mince pie eating, here are some great blogs and videos to read and watch: Blogs of the month Star Schema Design…
November News
Blogs 1. ORA-00479: RVWR process terminated with error followed by ORA-479 Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution. 2. Natural Selection & Converged Databases (Oracle finds good solutions…
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
Latest blogs and videos
Just a few for these chilly October/November evenings … Blogs of the Week 1. Announcing Oracle APEX 20.2 Joel Kallman shares (the original post is here) : “This release of APEX introduces several new features and enhancements to help developers be more productive than ever before. From the all new Cards…